This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Day date glitch

Topic Labels: Dates & Timezones
Solved
Jump to Solution
313 2
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GGA
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Mar 09, 2024 02:16 AM

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

 

0 Kudos
Reply
1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto
Solved See Solution in Thread

‎Mar 09, 2024 03:54 AM

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

Reply
2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto
Solved See Solution in Thread

‎Mar 09, 2024 03:54 AM

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?


Reply
GGA
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Mar 09, 2024 07:04 PM

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

Reply
Copyright © 2024 Khoros, LLC