ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: orlando_acevedo on June 22, 2018, 06:31:25 pm

Title: Date format not working when exporting to excel
Post by: orlando_acevedo on June 22, 2018, 06:31:25 pm

Date is displaying with the correct format on the screen, but when exporting, the column becomes text and the dates are displayed with format yyyy-mm-ddT00:00:00.00.
Is there something special that needs to be done so that it is exported with the correct format?

Thank you.

Title: Re: Date format not working when exporting to excel
Post by: paramvir on June 23, 2018, 11:34:00 am

Please share a test case or following

1. Version of grid.

2. column.format

3. column cell value data sample.

4. column.dataType

Title: Re: Date format not working when exporting to excel
Post by: orlando_acevedo on June 28, 2018, 11:35:27 pm

Hi. Here is the information:

1. Version 5.1

2. Column.format: "#,###.00"

3. Values are decimal

4. Column.dataType: "float"

Thank you for your help.

Orlando.

Title: Re: Date format not working when exporting to excel
Post by: paramvir on June 29, 2018, 10:55:10 am

But your original question was about date column. You have to apply date format to date values.

https://paramquery.com/pro/api#option-column-dataType