topic Re: Numeric convert to date format in QlikView

Numeric convert to date format

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 06 Jun 2018 08:55:19 GMT

Hi kate,

Try this:

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

Thanks

tresB — Wed, 06 Jun 2018 09:14:27 GMT

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 — Wed, 06 Jun 2018 10:23:48 GMT

Hi,

please read this:

HTH

André Gomes