Question

2
Replies
1504
Views
 santosh laxmaihgari (santosh0115)
Anthem Inc

Anthem Inc
US
santosh0115 Member since 2016 11 posts
Anthem Inc
Posted: April 17, 2018
Last activity: April 17, 2018
Posted: 17 Apr 2018 10:56 EDT
Last activity: 17 Apr 2018 14:03 EDT
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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 17 Apr 2018 14:01 EDT
Akshay Sawai (AKSHAY)
Cognizant Technology Solutions
Lead System Architect
Cognizant Technology Solutions
CA

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.