Help

Time wrong on export to Google Sheets

537 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Karrie
4 - Data Explorer
4 - Data Explorer
Can anyone help me? I have an airtable set up with a start date and time and and end date and time for workshops I'm holding. I need to export it to google sheets so I can upload them into my ticket system. When I export the date it come in the wrong time. I've been playing with sheets with NO LUCK! This is a link to a public sheet of what I am trying to do if anyone would look at it and help I'd be forever grateful! See notes on the sheet in red. https://docs.google.com/spreadsheets/d/1m1nd5eKUod2kap9ELEctocg9BptIzKMogjJert5XCUM/edit?usp=sharing
1 Reply 1

Perhaps you could subtract the time in Airtable first via `DATEADD()` and then do the export?