Help

Extracted date through DATETIME_FORMAT shows wrong date

Topic Labels: Formulas
Solved
Jump to Solution
471 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!