Mar 11, 2020 10:52 AM
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!
Solved! Go to Solution.
Mar 13, 2020 10:02 AM
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.
Mar 13, 2020 10:02 AM
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.