Current Timestamp Not Updating on OTBI Report
Content
Hello,
I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was hoping to run an agent every minute to pick up any changes in the last minute. I am trying to use the below filter, but when I run the report the CURRENT_TIMESTAMP does not update every time the report/agent runs. When I run the report normally it has the Timestamp of the last time I edited the report, but if I refresh on the bottom of the report it will pull the current timestamp. Below is
1