topic Re: MakeDate Function - String to Date in QlikView https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485341#M181330 <HTML><HEAD></HEAD><BODY><P>Very useful doc, I have used the time stamp option.</P><P></P><P>Thank you</P><P></P><P>H</P></BODY></HTML> Sat, 14 Dec 2013 16:48:44 GMT 2013-12-14T16:48:44Z MakeDate Function - String to Date https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485338#M181327 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an Excel column called SystDate. This has a text string examples of which are 11/29/2013 8:02:04 AM or 12/7/2013 9:59:32 PM, Can someone assist with the formula I would use to convert this into a date using the "MakeDate" function. S</P><P></P><P>Thank You</P><P></P><P>Herbiec09</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 203px;"><TBODY></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 203px;"><TBODY><TR><TD class="xl80" height="20" width="203"></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 14 Dec 2013 15:51:45 GMT https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485338#M181327 2013-12-14T15:51:45Z Re: MakeDate Function - String to Date https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485339#M181328 <HTML><HEAD></HEAD><BODY><P>Makedate function is not taking a string, use date#() or timestamp#() functions for this, as advised by Michael:</P><P></P><P>Date#('<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">11/29/2013 8:02:04 AM</SPAN>','DD/MM/YYYY hh:mm:ss TT')</P><P></P><P>or</P><P></P><P>Date#(SystDate,'DD/MM/YYYY hh:mm:ss TT')</P><P></P><P>[edit:] </P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3102">http://community.qlik.com/docs/DOC-3102</A></P></BODY></HTML> Sat, 14 Dec 2013 15:53:42 GMT https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485339#M181328 swuehl 2013-12-14T15:53:42Z Re: MakeDate Function - String to Date https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485340#M181329 <HTML><HEAD></HEAD><BODY><P>Thank you very much, much appreciated.</P><P></P><P>Herbiec09</P></BODY></HTML> Sat, 14 Dec 2013 16:10:00 GMT https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485340#M181329 2013-12-14T16:10:00Z Re: MakeDate Function - String to Date https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485341#M181330 <HTML><HEAD></HEAD><BODY><P>Very useful doc, I have used the time stamp option.</P><P></P><P>Thank you</P><P></P><P>H</P></BODY></HTML> Sat, 14 Dec 2013 16:48:44 GMT https://community.qlik.com/t5/QlikView/MakeDate-Function-String-to-Date/m-p/485341#M181330 2013-12-14T16:48:44Z