Help

Day date glitch

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

why does a 'day date' formula, based on a 'start time' return a day as the day before, when the start time is before 8am? 

Here is my formula column which is based on my start day/time field

DATETIME_FORMAT(Start,"D-ddd")

 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Probably a timezone thing; try setting your "Start" day/time field to use the same timezone for all collaborators and see if your formula field updates correctly?

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Probably a timezone thing; try setting your "Start" day/time field to use the same timezone for all collaborators and see if your formula field updates correctly?

GGA
4 - Data Explorer
4 - Data Explorer

That was it! Thank you - I was set to USA time but I am in Australia 🙂