Apr 26, 2022 12:51 PM
I have a Google Sheet with 3 separate columns for Day Year and month … and I would like to instead enter a Date field …It’s a simple table I’m moving to Airtable because it’s more user friendly IMO. … iut’s for about 2000 records.
See the picture attached
Solved! Go to Solution.
Apr 26, 2022 03:19 PM
I figured it out. . there is a checkbox to not include time… thanks for all your help
Apr 26, 2022 02:04 PM
Welcome to the Airtable community!
Check out the DATETIME_PARSE()
formula function. It is documented in the Formula Field Reference. You may also need to refer to the list of format specifiers.
Apr 26, 2022 02:17 PM
I’ll check it out… .
FYI … I tried this CONCATENATE(Month,Day,Year) but it didn’t quite work out …
Apr 26, 2022 02:44 PM
I’m almost there … I first use concanate formula to string the text together and then I used Date time parse
the following formulat
DATETIME_PARSE({Text}, ‘M/D/YYYY’)
It worked except that it displays the time as 12:00am … is there an edit I can do to remove the time.
Apr 26, 2022 03:19 PM
I figured it out. . there is a checkbox to not include time… thanks for all your help