Error message with Date_Format and & formula

[erinhorn12]

I am trying to combine two fields into one. Both fields have a date and I am getting an error message when I try to combine them with & or Concatenate formula. 

DATETIME_FORMAT({Date PL NT}, 'l') & " " & DATETIME_FORMAT({Date of PL Local Orders}, 'l')

HELP!  

[stevendasilva]

@erinhorn12 What is your goal with the formula? What is the desired outcome, if you could provide an example that would be awesome. 

[Alexey_Gusev]

Hi,
both fields must have 'Date' type (or compatible).  If it's a text field containing date, it's a string (that looks like a date). I suppose you are trying to take 2 text fields into one text field, but work with it using date functions.
to do it, you need to turn it from text to date first. I think you should use DATETIME_PARSE({Field}) instead of {Field} in you formula