GetOutlookMailMessages - how to filter emails with todays date only

Hi,

I was wondering what the syntax would be to filter the GetOutlookMailMessages activity to only display emails with todays date.

I currently have the following: “@SQL=(urn:schemas:httpmail:subject like ‘Test Invoices%’)”

Thanks

Hi @TRX,

The result of the filter @SQL=(urn:schemas:httpmail:subject like ‘Test Invoices%’) will be list of mailmessage. So pass that list of maillmessage through For each -> if condition with listofmailmessage.Headers(“Date”) = current date and follow your process steps.

I hope this helped you to find the solution. If yes please mark this as a solution

Thanks,
Arun Vignesh S
We only have what we give

1 Like