Skip to main content
Solved

Extracted date through DATETIME_FORMAT shows wrong date

  • June 26, 2023
  • 1 reply
  • 16 views
A
Forum|alt.badge.img+2

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!

 

Best answer by Harsh2

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!

1 reply

H
Forum|alt.badge.img+4
  • Harsh2
  • Participating Frequently
  • 23 replies
  • Answer
  • June 26, 2023

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!


Terms & ConditionsAccessibility statement