Skip to main content

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? 

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

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


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

Reply


Terms & Conditions