When you export Trello Board to CSV when viewing it Dates (Start, Due, etc) look something like:
2024-04-16T14:28:00.000Z
Is there anyway to export it without the time component so I would just get 2024-04-16 or I will need to to do it on Excel? If it's on Excel what's the best method to split the data.
Thanks
Hi @Ashish Dobriyal - We don't currently have a way to modify the date format, however you can try formatting it automatically in Excel as you've mentioned. Here's some information from an article I found with a similar request: https://superuser.com/questions/1455511/how-to-convert-utc-to-typical-date-format-in-excel
That's what I ended up doing, created a macro for it on excel. Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.