Help

Date and Time import from google sheets

Topic Labels: ImportingExporting
Solved
Jump to Solution
1563 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sara_Sierschula
4 - Data Explorer
4 - Data Explorer

My first post! This community has been very helpful. I’m still fairly new to airtable and hope someone can help with this problem.

I have a Google Sheet with a date field, a start time field, and a stop time field. I want to import it into a table with 2 fields: {date and start time} and {stop time}.

I tried to join fields in google sheets, then upload, but it only uploads the date correctly, and the time is ‘12:00am’. I’ve tried different date/time formats, but that hasn’t worked, and made the problem worse in some cases. For example it only works with the 12 hr format, when I tried 24 hour, neither the date nor time uploaded.

Any help or suggestions would be greatly appreciated!

google vs airtable date and time

1 Solution

Accepted Solutions
Sara_Sierschula
4 - Data Explorer
4 - Data Explorer

I got help from Airtable - here is the format:

ID, Date
1, 2020-03-04T10:20:00.000
2, 2020-02-01T20:15:00.000
3, 2020-04-30T01:00:00.000

I did a join formula in google using ‘T’ as the delimiter.

image

See Solution in Thread

1 Reply 1
Sara_Sierschula
4 - Data Explorer
4 - Data Explorer

I got help from Airtable - here is the format:

ID, Date
1, 2020-03-04T10:20:00.000
2, 2020-02-01T20:15:00.000
3, 2020-04-30T01:00:00.000

I did a join formula in google using ‘T’ as the delimiter.

image