Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date override formula returns wrong date

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1353 2
cancel
Showing results for 
Search instead for 
Did you mean: 
_Barry_Rashawn_
4 - Data Explorer
4 - Data Explorer

This is the formula i am using to manually override my default date entry IF({Date Override Entry} = BLANK(),{Default Mixed Date}, {Date Override Entry}) i attached a screen shot that shows the result that i am getting. It returns a result that is a day off and i am not sure i am not sure why. Thanks in advance any help it is much appreciated. :pray:

Screen Shot 2020-11-21 at 11.57.57 AM|700x308

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

It’s a time zone issue. For more understanding of time zones, explore my answer here:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

It’s a time zone issue. For more understanding of time zones, explore my answer here:

THANK YOU SO MUCH WILL LOOK Check that now!