Help

Datetime_Format WRONG DATE after 12:00

Topic Labels: Formulas
206 1
cancel
Showing results for 
Search instead for 
Did you mean: 
NicoleFleit
4 - Data Explorer
4 - Data Explorer

Hello, I need help structuring my datetime_format as it has been showing inaccurate days.

What I want is to have ~ Live Event ~ On-Air Start date(MMDDYY) and my formula is below:

NicoleFleit_0-1729797165404.png

However, with this formula, it is producing a date that is the following day when any time is past 12:00. I'm using the 24 hour time clock.

NicoleFleit_1-1729797419695.png

Can someone help me fix this?

 

1 Reply 1

Might be a timezone issue.  Try making both fields use the same timezone and see whether that helps

Screenshot 2024-10-25 at 9.39.40 AM.png