CurDate Beast Mode Showing Tomorrow's Date

user10986
user10986 Member
in Beast Mode

Is there a way that I can ensure the curdate function always uses EST time zome to return the correct date? For instance, at 8:50 pm, the cur date function is displaying 2/4 when I want it to display 2/3.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    CURDATE returns the current date in UTC format. If you want to convert it to EST you'll need to subtract hours from the UTC time to get EST time.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    CURDATE returns the current date in UTC format. If you want to convert it to EST you'll need to subtract hours from the UTC time to get EST time.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories