Hello All,
I’m able to get the SQL String but I’m not sure how to escape everything to make sure it’s valid in the Filter box option in the activity:
(“urn:schemas:httpmail:fromname” LIKE ‘%test@gmail.com%’ AND (“urn:schemas:httpmail:datereceived” >= ‘3/28/2021 8:45 PM’ AND “urn:schemas:httpmail:datereceived” <= ‘3/28/2021 8:46 PM’))
I tried this: (Basically putting double quotes around for every " or ')
“@SQL= " +”(""“urn:schemas:httpmail:fromname”"" LIKE “’”%test@gmail.com%"’" AND (""“urn:schemas:httpmail:datereceived”"" >= “’“3/28/2021 8:45 PM”’” AND “”“urn:schemas:httpmail:datereceived”"" <= “’“3/28/2021 8:46 PM”’”))"
Not working and I couldn’t find a compiler to help me out online.
Thanks!
Best Regards,