+1I 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.
+9@erinhorn12 What is your goal with the formula? What is the desired outcome, if you could provide an example that would be awesome.
+25Hi,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.