Question
2
Replies
1391
Views
Anthem Inc
Posted: April 17, 2018
Last activity: April 17, 2018
Closed
Solved
Function to get yesterday date time at 6:00am EST
Hi,
I have a requirement to get date time of yesterday 6:00 AM EST everyday in order to incorporate this in a RD which fetches data during that time.
Thanks in Advance!!
You can use below logic:
You can use below functions to achieve this:
param.PastDate = @addDays(@getCurrentTimeStamp(),-1,true,pxRequestor.pyCalendar)
param.PastDateTime = @pxGetSpecifiedTimeOnDate(param.PastDate, 18, 00, 0, "")
You will get result in GMT timezone.