DATE#

[Anonymous]

Hi,

I am loading multiples xls files, with *.xls, and i have multiples formats of date. But, i can not use

     date#(RENEWAL_DATE,'M/D/YYYY''YYYYMMDD'). I tried with , and ; between, but it says that date# takes only 2 parameters. How can i make to use date# for multiples formats?

Thank you,

Cosmina

[MK_QSL]

Check below blog posts...

The Date Function

Why don’t my dates work?

Get the Dates Right

Check Page 7 of below..

QlikView Date fields

[marcus_sommer · Accepted solution]

You could use alt() to check of various different formattings like:

alt(date#(RENEWAL_DATE,'M/D/YYYY'), date#(RENEWAL_DATE,'YYYYMMDD'))

- Marcus