topic Re: DOB from id no in QlikView https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577628#M1101253 <HTML><HEAD></HEAD><BODY><P>If Field = '1234dddddd567'</P><P>use</P><P>mid(Field,5,6)</P><P>Regards</P></BODY></HTML> Tue, 15 Apr 2014 08:08:58 GMT antoniotiman 2014-04-15T08:08:58Z DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577627#M1101252 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I am trying to extract the DOB from a 13 digit identification number in qlikview.</P><P></P><P>Please HELP.</P><P></P><P>Regards</P><P>Esmeralda</P></BODY></HTML> Tue, 15 Apr 2014 07:49:57 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577627#M1101252 2014-04-15T07:49:57Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577628#M1101253 <HTML><HEAD></HEAD><BODY><P>If Field = '1234dddddd567'</P><P>use</P><P>mid(Field,5,6)</P><P>Regards</P></BODY></HTML> Tue, 15 Apr 2014 08:08:58 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577628#M1101253 antoniotiman 2014-04-15T08:08:58Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577629#M1101254 <HTML><HEAD></HEAD><BODY><P>What is a DOB?</P></BODY></HTML> Tue, 15 Apr 2014 08:11:33 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577629#M1101254 alexandros17 2014-04-15T08:11:33Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577630#M1101257 <HTML><HEAD></HEAD><BODY><P>Date of Birth</P></BODY></HTML> Tue, 15 Apr 2014 08:12:52 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577630#M1101257 2014-04-15T08:12:52Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577631#M1101259 <HTML><HEAD></HEAD><BODY><P>Give me some examples of DOB</P></BODY></HTML> Tue, 15 Apr 2014 08:13:23 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577631#M1101259 alexandros17 2014-04-15T08:13:23Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577632#M1101261 <HTML><HEAD></HEAD><BODY><P>what is your 13 digit no and which location DOB if it is in string then use</P><P></P><P>Right, Mid, Left for extraction</P></BODY></HTML> Tue, 15 Apr 2014 08:15:01 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577632#M1101261 its_anandrjs 2014-04-15T08:15:01Z Re: DOB from id no https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577633#M1101262 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;">Use below line in your script instead of DOB</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.800000190734863px;"><STRONG>DATE(Date#(Left(DOB,10), 'YYYY/MM/DD')) as DOB</STRONG><BR /></SPAN></P></BODY></HTML> Tue, 15 Apr 2014 08:27:15 GMT https://community.qlik.com/t5/QlikView/DOB-from-id-no/m-p/577633#M1101262 MK_QSL 2014-04-15T08:27:15Z