Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Numeric convert to date format

Hi Communities,

I was trying to load an excel file to qlikview, there's one column contain the date information called YearMonth, the format like 201801.

Once the excel loaded in the qlikview, the date convert to numeric automatically, the it shows 43101.

I'm trying to convert it to date format by using Date() and Date#(), but the format wasn't converted well.

Please attached example is for your reference.

Thanks a lot

Kate

3 Replies
Creator
Creator

Hi kate,

Try this:

= DATE#((Today()),'MM/D/YYYY')

Thanks

MVP
MVP

If you are getting number in qlik while loading, you could use only date() to format it like:

Load

          Date(NumberFromExcel, 'YYYYMM') as Date         // use your desired date format in date()

Specialist II
Specialist II

Hi,

please read this:

Get the Dates Right

HTH

André Gomes