topic DATE# in QlikView https://community.qlik.com/t5/QlikView/DATE/m-p/1217016#M861621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am loading multiples xls files, with *.xls, and i have multiples formats of date. But, i can not use </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 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?</P><P></P><P>Thank you,</P><P>Cosmina</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z DATE# https://community.qlik.com/t5/QlikView/DATE/m-p/1217016#M861621 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am loading multiples xls files, with *.xls, and i have multiples formats of date. But, i can not use </P><P>&nbsp;&nbsp;&nbsp;&nbsp; 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?</P><P></P><P>Thank you,</P><P>Cosmina</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/DATE/m-p/1217016#M861621 Anonymous 2020-11-25T16:16:04Z Re: DATE# https://community.qlik.com/t5/QlikView/DATE/m-p/1217017#M861622 <HTML><HEAD></HEAD><BODY><P>Check below blog posts...</P><P><A href="https://community.qlik.com/qlik-blogpost/4002">The Date Function</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P></P><P>Check Page 7 of below..</P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Mon, 09 Jan 2017 14:45:54 GMT https://community.qlik.com/t5/QlikView/DATE/m-p/1217017#M861622 MK_QSL 2017-01-09T14:45:54Z Re: DATE# https://community.qlik.com/t5/QlikView/DATE/m-p/1217018#M861623 <HTML><HEAD></HEAD><BODY><P>You could use alt() to check of various different formattings like:</P><P></P><P>alt(date#(RENEWAL_DATE,'M/D/YYYY'), date#(RENEWAL_DATE,'YYYYMMDD'))</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 09 Jan 2017 14:46:32 GMT https://community.qlik.com/t5/QlikView/DATE/m-p/1217018#M861623 marcus_sommer 2017-01-09T14:46:32Z