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.