Not able to Filter the email received today

Help
1

Hi, I want to read the email if it has been received today and subject is ABC. I have stored ABC in a variable. Below is the logic I have used in get outlook email address. I am not getting the desired output. Please can you help.

“[Subject]=” + EmailSubject AND + [ReceivedTime] >= + today.ToString(“MM/dd/yyyy hh:mm tt”)

2

There a few solutions in the forum on this topic.

Another Solution is :

"@SQL= %today(urn:schemas:httpmail:datereceived)% AND urn:schemas:httpmail:subject='"+EmailSubject+"'"

Today : %today(urn:schemas:httpmail:datereceived)%

Yesterday : %yesterday(urn:schemas:httpmail:datereceived)%

More Info:

2 Likes
3

Thanks for sharing, soo helpful. If in case want to do for particular date with no timestamp then what will be the expression? Please let me know.