topic Re: Text Date to Number Date? in QlikView https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309864#M114417 <HTML><HEAD></HEAD><BODY><P>If you replace '21 January 2011' by the field name, the function will handle the value in the field.</P><P></P><P>An example is attached.</P></BODY></HTML> Wed, 18 May 2011 18:09:05 GMT nagaiank 2011-05-18T18:09:05Z Text Date to Number Date? https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309861#M114414 <HTML><HEAD></HEAD><BODY><P>Is it possible to convert and date in the format, for example, 21 January 2011, into a number date format in QlikView, such as DD/MM/YYYY?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 18 May 2011 17:09:59 GMT https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309861#M114414 2011-05-18T17:09:59Z Text Date to Number Date? https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309862#M114415 <HTML><HEAD></HEAD><BODY><P>Interpret the external date into number format using date# and then format the internal date into any desired formt using datefunction.</P><P></P><P>In your case, you may try</P><P></P><P>date(date#('21 January 2011','DD MMMM YYYY'),'DD/MM/YYYY')</P></BODY></HTML> Wed, 18 May 2011 17:22:10 GMT https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309862#M114415 nagaiank 2011-05-18T17:22:10Z Text Date to Number Date? https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309863#M114416 <HTML><HEAD></HEAD><BODY><P>Thanks for the response. How would i make this work with any text date, rather than just 21 January 2011?</P></BODY></HTML> Wed, 18 May 2011 17:58:50 GMT https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309863#M114416 2011-05-18T17:58:50Z Re: Text Date to Number Date? https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309864#M114417 <HTML><HEAD></HEAD><BODY><P>If you replace '21 January 2011' by the field name, the function will handle the value in the field.</P><P></P><P>An example is attached.</P></BODY></HTML> Wed, 18 May 2011 18:09:05 GMT https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309864#M114417 nagaiank 2011-05-18T18:09:05Z Text Date to Number Date? https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309865#M114418 <HTML><HEAD></HEAD><BODY><P>Brilliant, works just as i require. Thanks for the help.</P></BODY></HTML> Wed, 18 May 2011 18:11:46 GMT https://community.qlik.com/t5/QlikView/Text-Date-to-Number-Date/m-p/309865#M114418 2011-05-18T18:11:46Z