Skip to content


Bulk CRM Query – DateTime Criteria

Chris asked 5 years ago
I’m trying to pull back all CRM accounts where a custom field is in the past.
My Expression is pointing to the rlevant field but I can’t figure out how to set the Criteria to now.
I’ve tried:
< DateTime.Now
< DateTime.Now.ToString(‘MM/dd/yyyy’)
but neither work
Ethan Sorenson Staff answered 5 years ago
Your script looks close, but you are using single quotes instead of double quotes. I would also first save the value to a variable such as:
Current = DateTime.Now.ToString(“MM/dd/yyyy”)
Chris replied 5 years ago

Thanks, that’s solved it

If you would like to submit an answer or comment, please sign in to the eOne portal.