Nov 29, 2023
I am getting start and end date as a text in one field.BUT format could be different in each record (mm/dd/yyyy OR yyyy-mm-dd)
I want to find a formula to split A field (which could be formatted in two ways) into start (B) and end (C) datesTime shown in B and C is not relevant. Most important to have it formatted as date.
Thank you in advance for any input into this!