Our organization time zone is pst. And user timezone is also pst. So, I need the records created between 4:31 PM pst to 4:29 AM pst.
I tried to create a formula field like this. And it's showing hours now But I am unable to figure out how to setup minutes & filter only records created under this duration
VALUE(MID (TEXT (CreatedDate -7/24),12,2))