topic Re: Convert number to date in QlikView https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631927#M476940 <HTML><HEAD></HEAD><BODY><P>date(Columnname, 'MM/DD/YYYY') as Date</P></BODY></HTML> Tue, 13 May 2014 20:18:11 GMT 2014-05-13T20:18:11Z Convert number to date https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631926#M476939 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>When I load my data, one of my date columns comes up with numbers instead of actual date eg '41149'. How do I convert this to a date in the load script because when I try to apply the Month(Date) function it brings back null values.</P><P></P><P>Thanks</P><P></P><P>H</P></BODY></HTML> Tue, 13 May 2014 20:16:20 GMT https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631926#M476939 2014-05-13T20:16:20Z Re: Convert number to date https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631927#M476940 <HTML><HEAD></HEAD><BODY><P>date(Columnname, 'MM/DD/YYYY') as Date</P></BODY></HTML> Tue, 13 May 2014 20:18:11 GMT https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631927#M476940 2014-05-13T20:18:11Z Re: Convert number to date https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631928#M476941 <HTML><HEAD></HEAD><BODY><P>thanks</P></BODY></HTML> Tue, 13 May 2014 20:22:11 GMT https://community.qlik.com/t5/QlikView/Convert-number-to-date/m-p/631928#M476941 2014-05-13T20:22:11Z