Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: DATETIME_FORMAT returning wrong time - 24hours system

Solved
Jump to Solution
963 0
cancel
Showing results for 
Search instead for 
Did you mean: 
MCC
6 - Interface Innovator
6 - Interface Innovator

I am struggling to get the DATETIME_FORMAT to return the correct time for me. 

For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FORMAT({Start Date},'HH:mm')

However, it keeps returning the time as 16:00.

Can anyone help? 

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, might be to do with the time zone you've got set up for the formula field?

Screenshot 2023-05-30 at 3.13.31 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hmm, might be to do with the time zone you've got set up for the formula field?

Screenshot 2023-05-30 at 3.13.31 PM.png

Awesome thank you so much!!! It worked!!!