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
and:
< DateTime.Now.ToString(‘MM/dd/yyyy’)
but neither work
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 5 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”)
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