Hello,

I'm having trouble getting dates to consistently come out in "dd/mm/yyyy" format. When the day <= 12, it utilises this as the month.

I've attached 3 files:
- The raw data from SQL Server (the column datatype is "datetime").
- The code I'm using to write to and format the cell using EasyXLS.
- The output in Excel. The orange column is what EasyXLS is outputting; the green column is what I'm expecting based on my ".setFormat.."

Thanks in advance!

Hi,

You need to extract data from sql in "mm/dd/yyyy" format and then set the data type as DataType.DATE for best performances. Other similar date formats are recognized as M/d/y or M-d-y.

A date value is a calendar date that can also include the time. We recommend entering the date values in "mm/dd/yyyy" format (i.e. 12/23/2005) for optimization purposes. Later, to apply a different format, the cell can be formatted using the desired date format, as you did.

You might want to check this chapter in our online User Guide
https://www.easyxls.com/manual/basics/i ... ate-values

Thanks oana! Using your suggestion I was able to fix by reorganising the date format in the Classic ASP to "mm/dd/yyyy" before writing to the spreadsheet, and this fixed it <- src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" />

That is good news. You are very welcome, James!