Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Time change after CONCATENATE formula

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1042 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
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