Extracted date through DATETIME_FORMAT shows wrong date

[ac-gh]

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!

[Harsh2 · Accepted solution]

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!