Skip to main content
Solved

Day date glitch

  • March 9, 2024
  • 2 replies
  • 19 views

Forum|alt.badge.img+4
  • New Participant

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")

 

Best answer by TheTimeSavingCo

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?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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?


Forum|alt.badge.img+4
  • Author
  • New Participant
  • March 10, 2024

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