To convert field values with date value but with text type in a spreadsheet.
Choose data > Text to columns..
Choose the delimiter for example “/” and it will generate 3 columns.
Can reformat the date with =A3&-A2&-A1 (YYYY-MM-DD)
Convert date of text type to formatted date
Leave a reply