Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Is there a formula to combine 3 separate columns for "day" "Month" "year' .. into one Date field

Topic Labels: Dates & Timezones
Solved
Jump to Solution
2240 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Jerry_B
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Month Day year

1 Solution

Accepted Solutions
Jerry_B
5 - Automation Enthusiast
5 - Automation Enthusiast

I figured it out. . there is a checkbox to not include time… thanks for all your help

See Solution in Thread

4 Replies 4

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.

Jerry_B
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ll check it out… .

FYI … I tried this CONCATENATE(Month,Day,Year) but it didn’t quite work out …

Jerry_B
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Jerry_B
5 - Automation Enthusiast
5 - Automation Enthusiast

I figured it out. . there is a checkbox to not include time… thanks for all your help