+6I 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?
Best answer by TheTimeSavingCo
Hmm, might be to do with the time zone you've got set up for the formula field?
+31Hmm, might be to do with the time zone you've got set up for the formula field?
+6Hmm, might be to do with the time zone you've got set up for the formula field?
Awesome thank you so much!!! It worked!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.