Date Range CSV format #24
Unanswered
stupidaddfly
asked this question in
Q&A
Replies: 1 comment
-
Use comma to separate dates. Also put your range column in quotes
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I'm merging my old database with a new one and I've converted my xlsx on my own to CSV but I couldn't manage to get date ranges correctly and I wanted to confirm whether I did it right.
In Notion have one column called Work Time with date property that uses date range to determine time I spent working.
I Excel I have the same column name, with date range between date 1 and date 2 being like this "YYYY-MM-DDTHH:MM:SSSZ/YYYY-MM-DDTHH:MM:SSSZ", or on live example "2023-03-03T10:02:000Z/2023-03-03T19:13:000Z" yet when I import merge CSV the date range isn't recognized. Could I ask for help, how should I format my date range so it works properly?
Thanks in advance!
Beta Was this translation helpful? Give feedback.
All reactions