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
Best answer by Jerry_B
I figured it out. . there is a checkbox to not include time… thanks for all your help
+29Welcome 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.
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.
I’ll check it out… .
FYI … I tried this CONCATENATE(Month,Day,Year) but it didn’t quite work out …
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.