Hi,
How to get records created before 09/09/2016 11:41 AM by using Advanced find? I put time in search criteria, but looks CRM just check the date.
Any way I can query the hour? Thanks a lot!
Carys
*This post is locked for comments
Hi,
As Aiden mentioned there is not any way to specify time in query.
but you can try exporting data to excel and then remove records which are create after
09\09\2016 11:41 AM
When doing advanced find, do query like
Created On On or Before 9/10/2016
and add created on Column in result set, then export to Excel and remove records which are create after 9/9/2016 11:41 AM.
Thanks a lot!
Hi,
Unfortunately, you can't query CRM down to the time value usin any technique (SDK, Fetch, Advanced Find, etc). All the datetime comparisons are at the date level. It's a real pain when time is important because you need to retrieve all the values then filter the resulting list.
Hope this helps! I'd appreciate if you'd mark this as Answering your question.
Thanks,
Aiden
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (