Numeric date

[tmumaw]

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

[MK_QSL]

Should not happen like this..

but you can use Date(YourDateField) as YourDateField in script..

[simran04]

Use Date(Date#(FieldName,Formatyouwant),Formatyouwant)

[Chanty4u]

which database you are using ?

try

date(Datefield) as Date  [as suggested by manish]

[Anonymous]

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.

[tmumaw]

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