Question2Replies1391Views×Close popoversantosh laxmaihgari (santosh0115) Anthem Inc Anthem Inc US View ProfileSend Message santosh0115 Member since 2016 11 posts Anthem Inc Posted: April 17, 2018Last activity: April 17, 2018Posted: 17 Apr 2018 10:56 EDTLast activity: 17 Apr 2018 14:03 EDT Closed Solved Function to get yesterday date time at 6:00am ESTHi,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 popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post, learn more×Close popover 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: 2 years agoPosted: 17 Apr 2018 14:01 EDT×Close popoverAkshay Sawai (AKSHAY) Cognizant Technology Solutions Lead System Architect Cognizant Technology Solutions CA View ProfileSend MessageAKSHAY Cognizant Technology Solutions replied to santosh0115You 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. Posted: 2 years agoPosted: 17 Apr 2018 14:03 EDT×Close popoversantosh laxmaihgari (santosh0115) Anthem Inc Anthem Inc US View ProfileSend Messagesantosh0115 Anthem Inc replied to AKSHAYthanks!!