How to fetch Last 24hrs old data in a report definition, from 12:00 - 12:00 CST. OOTB Functions support Server Time Zone (GMT).

User Experience
, , ,
1

Hi All,

We are trying to fetch Records via a JOB.

Records has to be from 12:00-12:00 Mid Night CST/EST. In, Report Defination, we have OOTB Functions like yesterday today, but it is fetching records based on the server timezone which is GMT by default.

Any Suggestion would be helpful. Thanks!

2

@Priyesh

Try passing the btw times as param.

Lets take two params, FromDate and ToDate for the RD. So in JOB activity set this params FromDate and ToDate to be passed to RD. In RD put filter conditions, FromDate is greater or Equals and ToDate is Less than equals.

Try setting the Dates params using*:* @addToDate(@DateTime.CurrentDateTime(),0,-5,0,0) → Output will be CST Current Time, this will be To Date and @addToDate(@DateTime.CurrentDateTime(),0,-29,0,0) will be From Date.

-5 used to get the CST time which is in GMT.

3

@KishoreKumarM2533

We are calling the Report Defination from a data flow to fetch large number of records.

Data Flow Source: Report Defination

It’s not possible to send parameters from data flow to report defination.

Thanks!

Priyesh A

4

Created a custom function alias to fetch based on current time stamp -24 hrs. which solved the problem. Thanks!