Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date field conversion ?

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 ?

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
anbu1984
Master III
Master III

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

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