Skip to main content

Hello,


I have formatted the date but the hour displayed shows 1 hour less.

How can I display the exact time in hours and minutes in the field {date formatted} ?

The formula I use is :



DATETIME_FORMAT({Time slots},‘DD-MM-YYYY à HH:mm’)



How can we solve this ? 🤔


If you want the date/time as a text string, you can use SET_TIMEZONE(). It is documented in the Formula Field Reference.


Or if you want to keep the date/time as a date/time object, you can have the formula simply be the {Time slots} and use the formatting option of the formula field to specify the date and time format to switch the month and day around.

If you want the date/time as a text string, you can use SET_TIMEZONE(). It is documented in the Formula Field Reference.


Or if you want to keep the date/time as a date/time object, you can have the formula simply be the {Time slots} and use the formatting option of the formula field to specify the date and time format to switch the month and day around.


You solved my problem @kuovonne ! The appointment hours match in the two fields now. 🎉


I followed the instructions from your link and it did the job 🙂 :



DATETIME_FORMAT(SET_TIMEZONE({Time slots},‘Europe/Paris’),‘DD/MM/YYYY à HH:mm’)




Thank you so much 🙂

Reply


Terms & Conditions