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