Date field conversion ?

[#1]

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 ?

[jonathandienst · Accepted solution]

Hi

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

[anbu1984]

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

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