nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

date format is changing while opening CSV report into Excel

Migrateduser

Hi,
 
 I am using BIRT 2.2.2 and csv emitter for generating csv report. i am setting the date into String into BIRT design and format i am setting as "yyyy-mm-dd" using query and in query converting the same as String. When i am opening the report in Textpad, the date is coming in correct format, but when opening in excel the date is coming in dd/mm/yyyy format.
 
Let us know, if i need to update something in design to get the date in yyyy-mm-dd format while opening csv report in excel.
 
Thanks in advance,
 
Ashish

Find more posts tagged with

Comments

There are no comments yet