Need help with filtering users by last_found field in sys_user table

[bandlaa]

I have a custom field called last_found in the sys_user table. The field type is Date and Time. I want to filter users who were last found 12 hours ago.

I initially used a filter for 2 hours, which worked fine. But when I updated the filter to 12 hours, it stopped working.

Could someone please guide me on how to properly filter users based on the last_found field for the last 12 hours?

Thanks in advance!

Code for 2 hours : 

u_accc_last_foundONLast 2 hours@javascript:gs.beginningOfLast2Hours()@javascript:gs.endOfLast2Hours()

code for 12 hours: u_accc_last_foundONLast 12 Hours@javascript:gs.beginningOfLast12Hours()@javascript:gs.endOfLast12Hours()

[Rafael Batistot]

hi @bandlaa, Try to 

u_accc_last_foundBETWEEN@javascript:gs.hoursAgoStart(12)@javascript:gs.now()

This will fetch all users whose last found is between now and 12 hours ago.

[Muhammad Salar]

Hello @bandlaa ,
Try this