Help

Time change after CONCATENATE formula

Topic Labels: Dates & Timezones
Solved
Jump to Solution
524 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SidStunt
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there.

In a field, I have used the formula below:

 
DATETIME_FORMAT({Datum gesprek}, 'DD-MM-YYYY HH:MM')&", "&{Traject begeleider}
 
Weirdly, the outcome makes the time change by a few minutes. I can't figure out why. Setting timezone, or changing other aspect doesn't help.
 
Schermopname (17).png
 
Could someone give a solution for this? Thank you!
1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

Hi,
MM is month, you should use mm

See Solution in Thread

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

Hi,
MM is month, you should use mm

SidStunt
5 - Automation Enthusiast
5 - Automation Enthusiast

Fantastic! Thank you