Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 29, 2023 06:17 PM
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?
Solved! Go to Solution.
May 30, 2023 12:14 AM
Hmm, might be to do with the time zone you've got set up for the formula field?
May 30, 2023 12:14 AM
Hmm, might be to do with the time zone you've got set up for the formula field?
Jun 01, 2023 04:40 PM
Awesome thank you so much!!! It worked!!!