Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Date override formula returns wrong date

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1142 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!