Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I just upgraded to 12.10.SR6 and my dates are automatically being converted to numeric date. Do I need to set something to stop this?
thanks
Should not happen like this..
but you can use Date(YourDateField) as YourDateField in script..
Use Date(Date#(FieldName,Formatyouwant),Formatyouwant)
which database you are using ?
try
date(Datefield) as Date [as suggested by manish]
In the folder main QVW....
SET ctipodocuFmeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
or verify ODBC/OLE DB driver,
or update the ODBC/OLE DB driver.
Let me explain in more detail what was happening. We upgraded our environment to 12.20 SR6 and also upgraded our SAP Connector to 6.6. When I would run my extracts against SAP to build my QVDs it would make all my dates in my QVDs a numeric date value. I have since worked with Qlik Support to get this resolved. I had to change a couple of values in the connect string Nulldate=False and NulldateLegancy=True. Now I have dates coming through into my QVDs, but the format is incorrect (YYYY-MM-DD). I thought there might be a place in one of the config dll's to make the format MM/DD/YYYY without changing everyone of my QVW's to accept the new format.
Thanks
Thom