How i can check if the modified date for the wiki pages is greater than specific date inside powershell script

Question

I have an enterprise wiki site collection inside my sharepoint server 2013 on-premises. now i want to write a powershell script, which will send an email mentioning all the wiki pages that have been modified after a specifc date.

so i wrote the following:-

$startdate = (Get-Date 2017-12-19)
$emailbody =""
$web = Get-SPWeb "http://*****/kb/wiki/"
$list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Pages"))  

foreach ($item in $list.items)
{

if ($item["modified"] -ge $startdate )
{
    $emailbody = $emailbody + "<br/>" +$item["Title"].toString()


}

}      

Write-Host "Sending Email"
     #SMTP server name
     $smtpServer = "****"

     #Creating a Mail object
     $msg = new-object Net.Mail.MailMessage

     #Creating SMTP server object
     $smtp = new-object Net.Mail.SmtpClient($smtpServer)

     #Email structure
     $msg.From = "****@******"
     #$msg.ReplyTo = "***@****"
     $msg.To.Add("****@*****")
     $msg.subject = "My Subject"
     $msg.body = "Hi , <br/>"+ "The following wiki pages have been modifed since 19/12/2017 <br/>"

     $msg.IsBodyHTML=$true
     #Sending email
     $smtp.Send($msg)

Now currently the problem is that the following check if ($item["modified"] -ge $startdate ) will always return false. Even i have wiki pages which were modified after 19/12/2017.. so can anyone advice on this please?

second question. is there a way to allow specifying the hours:minutes:seconds beside the day/month/year?

Answer 1

1) You need to first change the date format to ISO8601 DateTime format.

2) Instead of iterating over each list item, you should use CAML Query to filter these out.

Change your code as below:

$startdate = Get-Date 12/19/2017

$startDateIsoFormat = [Microsoft.SharePoint.Utilities.SPUtility]::CreateISO8601DateTimeFromSystemDateTime($startdate)

$emailbody =""
$web = Get-SPWeb "http://*****/kb/wiki/"
$list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Pages"))  

$spQuery = New-Object Microsoft.SharePoint.SPQuery;
$camlQuery = "<Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$startDateIsoFormat</Value></Geq></Where>";
$spQuery.Query = $camlQuery
$listItems = $list.GetItems($spQuery)

foreach ($item in $listItems)
{   
    $emailbody = $emailbody + "<br/>" +$item["Title"].toString()    
}  


/// rest of your code

Answer 2

$startdate = "21/12/2017 14:15:01" # string object so you need explict typecast
#startdate = Get-Date # DateTime object   
if (([DateTime]$item["Modified"]) -ge ([DateTime]#startdate)){...}

you can refer here for more PowerShell codes and scenarios as needed.

Answer 3

Replace the code below

if ($item["modified"] -ge $startdate )

with

if ($item["Modified"] -ge $startdate )