Excel Date format

Hello

I have a firebird database that I have an ETL setup that does a query and stores the results in MS-SQL.
From there I run a simple 'SELECT * FROM <MS-SQL TABLE>' and output to an excel writer. The excel file has all of the DATETIME columns formatted as numbers and not the readable datetime value.
I thought I would be slick and do the excel query converting the DATETIME to an NVARCHAR and just out put that to the excel file. I get the same results. I cannot format the field as it is stored in the excel file. If I pass the datetime through to the writer and try to format it there, everything is set to NULL as the formatter says the date value is invalid. I know that is not the case as I can get this to work in other tools, just not the ETL processor.

Can you assist me?
Thanks!

Hello

The writer format is excel format and not our software format
We will update the wiki to make it clear
There is a slight problem though at the moment it is not possible to enter such a long format into the format filed
That was addressed in the latest release.

Thanks, team. I was able to update the ETLs and the fields are as expected.

Mark