topic Re: Numeric date in QlikView

Numeric date

tmumaw — Fri, 16 Mar 2018 20:21:17 GMT

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

Re: Numeric date

MK_QSL — Fri, 16 Mar 2018 20:31:19 GMT

Should not happen like this..

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

Re: Numeric date

simran04 — Sun, 18 Mar 2018 12:40:37 GMT

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

Re: Numeric date

Chanty4u — Sun, 18 Mar 2018 17:30:33 GMT

which database you are using ?

try

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

Re: Numeric date

Anonymous — Sun, 18 Mar 2018 20:00:25 GMT

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.

Re: Numeric date

tmumaw — Mon, 19 Mar 2018 11:33:11 GMT

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