Support Article
getCurrentDateStamp returns Date ahead of server date
SA-46128
Summary
The @getCurrentDateStamp() function returns dates in GMT. The dates returned are ahead of the server date. The requirement is the server date.
Error Messages
Not Applicable
Steps to Reproduce
Configure the sever with a time zone (for example, EST) other than GMT. Use the @getCurrentDateStamp() function to retrieve the date.
Root Cause
The @getCurrentDateStamp() function was used, such that the Current Date was returned from 00:00 AM till 11:59 PM in the server’s time zone. However, the servers were in EST. Hence, after 8 PM EST, the next day’s date stamp was returned.
Resolution
Perform the following local-change to retrieve the current date in EST: Use @CurrentDate("yyyyMMdd", "EST") Rule Utility Function (RUF).
Published March 24, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.