Question
Date time discrepancies
Hi,
I am trying to get the next day from today's date. For eg: today is 18/9/2023. I need to get 19/09/2023. I tried using some day function to get the day and add 1 to it. I was testing with different timezones.
now() - 9/18/2023 10:50 PM PDT
now() + 1 - 9/19/2023 10:50 PM PDT
when I used day function on now() +1, its giving 20 instead of 19. I am not sure what is the issue or maybe I am missing some timezone offset. This is occuring when I tested for Pacific timezone. Its working fine for IST. Please help me on this.
a!localVariables(
local!date: now(),
local!endDate: now()+1,
local!day: day(local!endDate),
local!day
)


