Help

Date and/or Day not calculating correctly if after certain time

1773 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Melissa_Hanson1
5 - Automation Enthusiast
5 - Automation Enthusiast

image

I’ve got a date field with time, and if it’s after 8pm, and I do a formula to show the date, it gives the day after.
Ex: Date 3/23/18, 6pm = date shows 3/23/18
Date 3/23/18, 8pm = date shows 3/24/18

what is going on?

2 Replies 2

Check the formatting of your date fields to make sure ‘Use the same time zone (GMT) for all collaborators’ is toggled off (or on, as the case may be). The problem you’re describing is almost always indicative of someone in the Western Hemisphere with GMT time enabled.

That was it!!! Thank you so much!