Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to get user records that are updated after a particular time in the previous day

pallavikavuluru
Kilo Contributor

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

7 REPLIES 7

abhiyadav2001
Giga Expert

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


abhiyadav2001
Giga Expert

Hi Pallavi,



Any luck with resolving your issues?



Thanks,


Abhijeet


Thank you for this answer. I had the exact same issue and your solution works.