Spreadsheet date and time format

I’d like to add all new appointment bookings to an ODS spreadsheet. Unfortunately name and date are formated in a rare way even when only reading the ODS file. With this expression I’m perfectly able to to convert regular dates into this strange format, but I’d like to do that only for new written entries.
How can I prevent n8n from reading and interpreting date and time in this way? The entries already written should be untouched.

Hey @mokkin,

We will typically return the data as it is stored in the sheet so if the sheet has the data in this format that is how we are going to read it and we don’t really have an option for setting the data type for the fields so it would be a case of cleaning up the data as you go.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.