topic Text to date in QlikView https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577885#M1118413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My dataset has dates noted as follows:</P><P></P><P>03.06.2013</P><P></P><P>However, it are no dates; it is text, so I cannot do calculations with it. How do I change this to a real date, or a number (in this example to 41428), so I can do calculations with the dates?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 28 Jan 2014 14:04:35 GMT 2014-01-28T14:04:35Z Text to date https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577885#M1118413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My dataset has dates noted as follows:</P><P></P><P>03.06.2013</P><P></P><P>However, it are no dates; it is text, so I cannot do calculations with it. How do I change this to a real date, or a number (in this example to 41428), so I can do calculations with the dates?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 28 Jan 2014 14:04:35 GMT https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577885#M1118413 2014-01-28T14:04:35Z Re: Text to date https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577886#M1118414 <HTML><HEAD></HEAD><BODY><P>If day is first then month:</P><P>date#(YourDateField, 'DD.MM.YYYY')</P><P></P><P>If month is first then day:</P><P>date#(YourDateField, 'MM.DD.YYYY')</P></BODY></HTML> Tue, 28 Jan 2014 14:06:06 GMT https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577886#M1118414 Nicole-Smith 2014-01-28T14:06:06Z Re: Text to date https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577887#M1118415 <HTML><HEAD></HEAD><BODY><P>hi Dam</P><P>try this :</P><P>date(date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">03.06.2013</SPAN>,'DD.MM.YYYY'))</P></BODY></HTML> Tue, 28 Jan 2014 14:06:47 GMT https://community.qlik.com/t5/QlikView/Text-to-date/m-p/577887#M1118415 2014-01-28T14:06:47Z