Skip to main content
Solved

Time change after CONCATENATE formula

  • November 28, 2023
  • 2 replies
  • 15 views

Forum|alt.badge.img+4

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.
 
 
Could someone give a solution for this? Thank you!

Best answer by Alexey_Gusev

Hi,
MM is month, you should use mm

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • Answer
  • November 28, 2023

Hi,
MM is month, you should use mm


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • November 28, 2023

Fantastic! Thank you