Help

Re: Time change after CONCATENATE formula

Solved
Jump to Solution
838 0
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
13 - Mars
13 - Mars

Hi,
MM is month, you should use mm

See Solution in Thread

2 Replies 2
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
MM is month, you should use mm

SidStunt
5 - Automation Enthusiast
5 - Automation Enthusiast

Fantastic! Thank you