I have searched the forums for many threads like this, but is unable to get what i need working.
I need to filter emails based on the time after ticket submission and the subject title.
I have a datetime variable(DT_ticket) saved when submitting a ticket.
The subject contains “Ticket number:”
The following filter is not working:
“[ReceivedTime] > '”+DT_Ticket.ToString(“MM/dd/yyyy hh:mm tt”)+"’" +“AND [Subject] LIKE ‘ticket number:%’”
What should be the right syntax?