Converting a DATETIME field from MS SQL to a TRUE Date Time in Excel

[LeonelSanchezJr]

My DATETIME fields comes out as a TEXT field when the report runs from Webfocus to Excel.

The value in MS SQL is: 2005-05-19 16:22:00.000

When the dates come from Oracle, I use the syntax below to get 20-JUL-2005.

COMPUTE NEWDATE_1/DMYY = HDATE(OLDDATE,'DMYY'); AS 'dfield'

I want to be able to have the time retained, but as a DATETIME field in Excel.

What do I need to change in my syntax?

Thanks,

Leo ;-)