Post

1 follower Follow
0
Avatar

Exporting projects to excel yields inconsistent date formats

When I export a list of projects to Excel, the downloaded Excel file has multiple different formats for the same date column. I see mm-dd-yy and mm-yy-dd.  How can this be resolved? I can't use the Text to Columns feature to ensure the date formats are correct because the same column has multiple formats.

Farhan Virji Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Odd... if you go to the report properties and then column -> manage, on the right side do you see any format options you can change?

Guy 0 votes
Comment actions Permalink