topic Re: HELP | Convert unusual string into Date, and Time in QlikView https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786576#M472649 <HTML><HEAD></HEAD><BODY><P>Try the following expressions:</P><P>Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'MM-DD-YYYY')</P><P>Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'hh:mm:ss')</P></BODY></HTML> Thu, 25 Dec 2014 00:42:34 GMT nagaiank 2014-12-25T00:42:34Z HELP | Convert unusual string into Date, and Time https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786575#M472648 <HTML><HEAD></HEAD><BODY><P>Looked at lots of posts and am yet unable to convert the following into Date and Time fields.</P><P></P><P>Field is called LASTORDERDATE</P><P>Example value is: 01-APR-02 01.10.36.000000000 PM</P><P></P><P>I need to convert to </P><P>Date 04-01-2012</P><P>Time: 01:10:36 PM (or 13:10:36)</P><P></P><P>Any help is appreciated.</P></BODY></HTML> Wed, 24 Dec 2014 23:30:52 GMT https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786575#M472648 2014-12-24T23:30:52Z Re: HELP | Convert unusual string into Date, and Time https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786576#M472649 <HTML><HEAD></HEAD><BODY><P>Try the following expressions:</P><P>Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'MM-DD-YYYY')</P><P>Date(Date#('01-APR-02 01.10.36.000000000 PM','DD-MMM-YY hh.mm.ss.fffffffff TT'),'hh:mm:ss')</P></BODY></HTML> Thu, 25 Dec 2014 00:42:34 GMT https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786576#M472649 nagaiank 2014-12-25T00:42:34Z Re: HELP | Convert unusual string into Date, and Time https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786577#M472650 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.qlik.com/qlik-users/38270">NagaianK</A></P><P>Worked like a charm.</P></BODY></HTML> Thu, 25 Dec 2014 04:26:24 GMT https://community.qlik.com/t5/QlikView/HELP-Convert-unusual-string-into-Date-and-Time/m-p/786577#M472650 2014-12-25T04:26:24Z