Excel Extractor Output for Datetime Field

Answered

DB: SQL Server

My setting:

So the RESULT VIEWER shows DATETIME type field value like “2023-12-25” per my settings.
BUT - when I export via Excel Extractor - the value shown in Excel is “2023-12-25 00:00:00

The problem : 
with such value (“2023-12-25 00:00:00”) Excel (US locale) does not recognize it a date or formattable as date,
it sems Excel see it as STRING.
I have to remove the “00:00:00" (with find/replace). Then Excel recognizes it as DATE value.

So is it possible to output the same as seen in the result viewer (yyyy-mm-dd) - i.e. "WYSIWYG"

 

0
2 comments

thx,

3 years  and still not delivered, Christ

0

Please sign in to leave a comment.