How to adjust Date Formatting?

Question

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 ?  :thinking:

kuovonne · Accepted Answer

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.

Soly · Answer

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. :tada:

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

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

Thank you so much :slightly_smiling_face:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded