Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extracted date through DATETIME_FORMAT shows wrong date

Topic Labels: Formulas
Solved
Jump to Solution
1055 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ac-gh
4 - Data Explorer
4 - Data Explorer

Hi,

I have an event list that contains a Start Day column including time (needed in some instances, but often left as 0:00). As I would like a simplified view in some interfaces, I created a formula column to display the date without the time using the formula:

DATETIME_FORMAT({Start Day}, 'DD MMM YYYY')

However, the formula returns the wrong day, in fact Day -1. I imagine this is due to the 0:00 time being read wrong? 

Any suggestions to circumvent? Adding a formula to just +1 the day would probably not work for the events in which time is indicated.

Thanks!

 

1 Solution

Accepted Solutions
Harsh2
6 - Interface Innovator
6 - Interface Innovator

Hi @ac-gh 

This is most likely happening because you specified the timezone in CET.

Using the "SET_TIMEZONE" in your formula should fix the problem for you.

Hope this helps!

See Solution in Thread

1 Reply 1
Harsh2
6 - Interface Innovator
6 - Interface Innovator

Hi @ac-gh 

This is most likely happening because you specified the timezone in CET.

Using the "SET_TIMEZONE" in your formula should fix the problem for you.

Hope this helps!