Numeric convert to date format

[katetsan]

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

[Anonymous]

Hi kate,

Try this:

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

Thanks

[tresesco]

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()

[agomes1971]

Hi,

please read this:

Get the Dates Right

HTH

André Gomes