Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

When you export CSV the Date Columns have Time Attached any way to remove the Time.

Ashish Dobriyal April 4, 2024

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

1 answer

1 accepted

0 votes
Answer accepted
Lam
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 10, 2024

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

Ashish Dobriyal April 11, 2024

That's what I ended up doing, created a macro for it on excel. Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events