Task scheduler messes up date format in my PowerShell script

Question

Hello I have the following PowerShell script that calculates expired certificates and sends email about it.&nbsp;&nbsp;&nbsp;$Urls = @()
$Urls = "https://....",
"https://......",
"https://...."

$Result = @()

$MinimumCertAgeDays = 5000
$dummy = 0
$count = 1
$ErrorActionPreference= 'silentlycontinue'

Foreach ($url in $Urls)
{
[Net.ServicePointManager]::ServerCertificateValidationCallback = { $true }

$req = [Net.HttpWebRequest]::Create($url)
$req.GetResponse() | Out-Null
#$req.ServicePoint.Certificate.GetExpirationDateString()

$ExpirationDate = $req.ServicePoint.Certificate.GetExpirationDateString()
$ExpDateToDT = [Datetime]::ParseExact($ExpirationDate, "dd/MM/yyyy hh:mm:ss", $null)
$DayCount = ( $( $ExpDateToDT ) - $( Get-Date ) ).Days

If ( $DayCount -le $MinimumCertAgeDays )
 {  
 
 $dummy = 1

$Result += "
   $count) Certificate for Host: $url  Expires on -----&gt;  $ExpirationDate    Expires in -----&gt;  $DayCount DAYS `n "  
                                                                                     
  $count = $count + 1

}

If ($dummy -eq 1 )
 {

# Sender and Recipient Info
   $MailFrom = "myemail"
   $MailTo = "myemail"

# Sender Credentials
   $Username = "myusername"
   $Password = "mypass"

# Server Info
   $SmtpServer = "myserver"
   $SmtpPort = "myport"

# Message stuff
   $MessageSubject = "!!!!!!!!!!!!!!SOS CERTIFICATES ARE GOING TO EXPIRE!!!!!!!!!!!!!!!!!!" 
   $Message = New-Object System.Net.Mail.MailMessage $MailFrom,$MailTo
   #$Message.IsBodyHTML = $true
   $Message.Subject = $MessageSubject
   $Message.Body = $Result
   $Message.Priority = "high"

# Construct the SMTP client object, credentials, and send
   $Smtp = New-Object Net.Mail.SmtpClient($SmtpServer,$SmtpPort)
   $Smtp.EnableSsl = $true
   $Smtp.Credentials = New-Object System.Net.NetworkCredential($Username,$Password)
   $Smtp.Send($Message)
}&nbsp;&nbsp;&nbsp;The script runs successfully when i trigger it from Powershell ISE and i got the following email as exactly i wanted (please look image 1 below)IMAGE 1&nbsp;Nevertheless when i run the exact same script BUT this time through task scheduler in windows (in order to automate this procedure) i get the following results (please see image 2 below)IMAGE2&nbsp;So as it can be detected by image 2, through task scheduler i get a crazy negative number of days remaining for expiration and also the πμ word in Greek :).&nbsp;Can somebody may help on how to resolve that problem?&nbsp;Best regards,Alexandros

farismalaeb · Accepted Answer

Alexandros8888&nbsp;As I see it, its a Culture issue&nbsp;which account is used to run the script, let me tell you thisActually, your script is throwing an Exception, which is&nbsp;String was not recognized as a valid DateTimeBut it was not displayed and totally ignored due to $ErrorActionPreference.As a quick fix you will need to configure the account which is used to Run the script as with the same System TimeDate configuration or try to load the culturehttps://stackoverflow.com/questions/44654045/get-date-formatting-culturehttps://docs.microsoft.com/en-us/dotnet/api/system.datetime.parseexact?view=net-5.0The reason why the $Result is in minus when running it using the scheduler is&nbsp;$ExpDateToDT is Null&nbsp;&nbsp;Hope this helps.&nbsp;---------------------If this Answer help, please click on Best Response and give like&nbsp;

Forum Discussion

Task scheduler messes up date format in my PowerShell script

Share

Resources