topic Re: Date field conversion ? in QlikView

Date field conversion ?

Thu, 04 Dec 2014 05:23:34 GMT

I am very new to Qlik Sense and am trying to do something that is way above what I know. From the database this is what I get in the date and time field. 41976.972523. This number converts to this date and time. 2014-12-03 23:20:25.987. Is there a way to do this in Qlik Sense or is it best to create a SQL view and point Qlik Sense at the view ?

Re: Date field conversion ?

jonathandienst — Thu, 04 Dec 2014 05:29:32 GMT

A date is just a number formatted for display as a date or date/time. In your load script, you can get the date format:

LOAD ....

Date(myDateField) As myDateField,

...

SQL SELECT ...

myDateField,

...

HTH

Jonathan

Re: Date field conversion ?

anbu1984 — Thu, 04 Dec 2014 05:29:51 GMT

You can use Date() to convert your field into date and time

=Date(41976.972523,'YYYY-MM-DD hh:mm:ss.fff')