Help

Re: Error message with Date_Format and & formula

836 0
cancel
Showing results for 
Search instead for 
Did you mean: 
erinhorn12
4 - Data Explorer
4 - Data Explorer

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!  
2 Replies 2
stevendasilva
6 - Interface Innovator
6 - Interface Innovator

@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
13 - Mars
13 - Mars

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