How to get user records that are updated after a particular time in the previous day
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2015 02:45 AM
Hi All,
We are trying to query the user records (from the sys_user table) that are updated after 03:30 EST yesterday by using glide record. This has to be done everyday to get the new users. Can anyone suggest any solutions to do that.
Thanks,
Pallavi
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-26-2015 05:10 AM
Hi Pallavi,
Could you please try using encoded query ?
sys_updated_on>javascript:gs.dateGenerate('2015-08-26','15:30:00')
Give it a try.
Thanks,
Abhijeet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-30-2015 11:38 PM
Hi Pallavi,
Any luck with resolving your issues?
Thanks,
Abhijeet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-26-2015 06:39 PM
Thank you for this answer. I had the exact same issue and your solution works.