I have requirement to fetch data from table (data type) yesterday 10PM EST to CurrentDay 10PM EST based data type coloumn pxcreateDatetime having in EST Format

General
1

i have requirement to fetch data from table (data type) yesterday 10PM EST to CurrentDay 10PM EST based data type coloumn pxcreateDatetime having in EST Format

2

Create a Job Scheduler if this needs to be automated daily.

Create two parameters StartDate and EndDate in RD.
Before calling the report, set these parameters
StartDate - @FormatDateTime(@addToDate(@DateTime.CurrentDateTime(),-1,0,0,0), “yyyyMMdd”, “EST”, “”) + “T220000.000 EST” (Previous day)
EndDate - @FormatDateTime(@DateTime.CurrentDateTime(), “yyyyMMdd”, “EST”, “”) + “T220000.000 EST” - Current day
Apply Filters in RD
.pxCreateDateTime >= Param.StartDate
.pxCreateDateTime <= Param.EndDate

1 Like
3

Hi I moved this post to General spaces as it was not a GenAI specific question.