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
Ernst & Young LLP
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.
Ernst & Young LLP
IN
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
Ernst & Young LLP
IN
Created a custom function alias to fetch based on current time stamp -24 hrs. which solved the problem. Thanks!