Hi there!
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) dates
Time shown in B and C is not relevant. Most important to have it formatted as date.
| A | B | C |
| Test Dates (single line text) | Test Start Date (Formula Formatted by ISO) | Test End Date (Formula Formatted by ISO) |
| 11/28/2022 - 12/23/2022 | 2022-11-28 02:00 | 2022-12-23 02:00 |
| 2022-11-28 - 2022-12-23 | 2022-11-28 02:00 | 2022-12-23 02:00 |
Thank you in advance for any input into this!