Skip to main content
Solved

Date formate in a formula

  • April 30, 2020
  • 2 replies
  • 27 views

Hi people :grinning_face_with_big_eyes:

I am trying to create a concatenate formula including a date-field.
The date i the field is set to ‘european format’. But when I use it in the concatenate-formula, it gives me a different format and the hours as well…

Can somebody help?

Best answer by Jeremy_Oglesby

In your formula for the “Name” field, at the section where you bring in the date, surround the date being pulled in with this:

... DATETIME_FORMAT(<< your date >>, 'M/D/YYYY')...

2 replies

Forum|alt.badge.img+18

In your formula for the “Name” field, at the section where you bring in the date, surround the date being pulled in with this:

... DATETIME_FORMAT(<< your date >>, 'M/D/YYYY')...

  • Author
  • New Participant
  • April 30, 2020

In your formula for the “Name” field, at the section where you bring in the date, surround the date being pulled in with this:

... DATETIME_FORMAT(<< your date >>, 'M/D/YYYY')...

Great - this works, thanks!!