Question

2
Replies
1235
Views
santosh0115 Member since 2016 11 posts
Anthem Inc
Posted: 2 years ago
Last activity: 2 years 5 months ago
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!!

Low-Code App Development
Close popover
Moderation Team has archived post
Accepted Solution
Posted: 2 years ago

You can use below logic:


  • Get Previous day Date

  • Set Time on the date

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.
Share this page LinkedIn
Copied!