topic Re: How to Consolidate date formats? in QlikView https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21383#M784090 <HTML><HEAD></HEAD><BODY><P>Alt(date1(),Date2(),Date3(),)</P></BODY></HTML> Tue, 13 Mar 2018 18:35:42 GMT zebhashmi 2018-03-13T18:35:42Z How to Consolidate date formats? https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21381#M784086 <HTML><HEAD></HEAD><BODY><P class="">Hi,</P><P class=""><BR /></P><P class=""><BR /></P><P class="">I have a few tables that contains the date field,</P><P class="">I want to consolidate all date fields into one to create a master calendar, I was able to achieved that but the problem I am facing is the date field from the different tables comes in diferent date formats, how can I consolidate all date formats into one single format?</P><P class=""><BR /></P><P class=""><BR /></P><P class="">Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21381#M784086 jgarciaf106 2020-11-25T16:16:04Z Re: How to Consolidate date formats? https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21382#M784088 <HTML><HEAD></HEAD><BODY><P>You can use below functions to make different date formats to common format.</P><P>DATE</P><P>DATE#</P><P>ALT</P><P></P><P>Check this document..</P><P><A href="https://community.qlik.com/docs/DOC-3102">QlikView Date fields</A></P></BODY></HTML> Tue, 13 Mar 2018 18:35:27 GMT https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21382#M784088 MK_QSL 2018-03-13T18:35:27Z Re: How to Consolidate date formats? https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21383#M784090 <HTML><HEAD></HEAD><BODY><P>Alt(date1(),Date2(),Date3(),)</P></BODY></HTML> Tue, 13 Mar 2018 18:35:42 GMT https://community.qlik.com/t5/QlikView/How-to-Consolidate-date-formats/m-p/21383#M784090 zebhashmi 2018-03-13T18:35:42Z