Skip to content
+1-888-319-3663

COMMUNITY FORUM

Bulk CRM Query – DateTime Criteria

Chris asked 4 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
and:
< DateTime.Now.ToString(‘MM/dd/yyyy’)
but neither work
Answers
Ethan Sorenson Staff answered 4 years ago
Chris,
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 4 years ago

Thanks, that’s solved it


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