Question
CBA (Commonwealth Bank of Australia)
IN
Last activity: 6 Aug 2024 8:43 EDT
How to fetch Last 24hrs old data in a report definition, from 12:00 - 12:00 CST. OOTB Functions support Server Time Zone (GMT).
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!
Accepted Solution
CBA (Commonwealth Bank of Australia)
IN
Created a custom function alias to fetch based on current time stamp -24 hrs. which solved the problem. Thanks!
EvonSys
IN
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.
CBA (Commonwealth Bank of Australia)
IN
@Kishore Kumar Madduri
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
Accepted Solution
CBA (Commonwealth Bank of Australia)
IN
Created a custom function alias to fetch based on current time stamp -24 hrs. which solved the problem. Thanks!