Convert date (numeric value in milliseconds) to DD/MM/YYYY in QVD

[#1]

Hi guys,

To speed up performance I'd like to move the date conversions from the QVW to the QVD's. Below the code done in the QVW script, which should be converted to work in the QVD.

[CODE]date#(date(num(rslt_CreationTime)-2415020,'DD/MM/YYYY'),'DD/MM/YYYY') as [Result Creation Time][/CODE]

Unfortunately, I can't get it working.

FYI: maybe it's interessinting to know that we are connecting on a Progress database.

Any help is - as always - highly appreciated.

Kind regards,

Maarten

[hector]

Hi, maybe 1 problem is you have the functions in the reverse order

date(date#(num(rslt_CreationTime)-2415020,'DD/MM/YYYY'),'DD/MM/YYYY') as [Result Creation Time]

and check the value in blue, because you are saying that the result of the substract returns a value with '/' in it, i don't think so....

how works this DB with fields? are there "regular" (days since jan 1 1900) or Unix format or other? what is the 2415020 number?

if you can give us some example data to work with, that will be great.

rgds