Date override formula returns wrong date

[_Barry_Rashawn_]

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

[ScottWorld · Accepted solution]

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

Workday Formula calculates Sunday Dates. Need to EXCLUDE weekends Formulas

You’re doing it right. It’s a time zone issue. Check what your time zone settings are in the formatting tab for both your formula field & your original date field, and check what time your original date field has. If it doesn’t have a time at all, I think it evaluates to midnight. So if that’s midnight GMT and your formula field is not set to GMT and you’re In America, then it will show up in your calendar on the day before. You can override this in your formula by using the SET_TIMEZONE func…

[_Barry_Rashawn_]

THANK YOU SO MUCH WILL LOOK Check that now!