- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2023 12:14 AM
Hmm, might be to do with the time zone you've got set up for the formula field?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 30, 2023 12:14 AM
Hmm, might be to do with the time zone you've got set up for the formula field?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 01, 2023 04:40 PM
Awesome thank you so much!!! It worked!!!