Back date showing in jira while experting CSV format

Dipankar Choudhury April 26, 2023

when i add a query filter and experting to csv format when i open the csv file the correct date is not showing ...

can you help me team?

 

 

Thank you
Dipankar

1 answer

0 votes
Aron Gombas [Midori]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 26, 2023

What is the "incorrect" date? Are you sure that it is not caused by timezone differences?

Dipankar Choudhury April 26, 2023

But the date is showing in the ticket correctly when i experting to csv , then the excel file date is showing back date

Dipankar Choudhury April 27, 2023

Hi @Aron Gombas [Midori] 
can you please help me on that?

Aron Gombas [Midori]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 27, 2023

We develop the app Better Excel Exporter and it works correctly with date values, timezones and such. Maybe it is better if you that instead of investigating the root cause here.

See: https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=server&tab=overview

Suggest an answer

Log in or Sign up to answer