Hi,

We have a requirement where we need to fetch data which is 1 day old (24 hours) using a report defination from a Job.

As, Job uses background processing, it will take Today or Yesterday Functions in GMT (server time zone), where we have to run this job at 12:00 CST.

In order to use From and To in report, need to subtract 5 hours from current date time (for FROM Value)

How can we achieve this?

One way is to create a declare expression for a property and use it.

Secondly, using a function alias of type "Embed-UserFunction" and use in right side of the filter condition. But here the challenge is we don't have any OOTB for that. Need to have it custom. we may need to write SQL for this (currenttimestmp - Interval '5' Hour),  not sure if this will work.

Any suggestion would be useful. Thanks!