DOB from id no

[#1]

Hi All

I am trying to extract the DOB from a 13 digit identification number in qlikview.

Please HELP.

Regards

Esmeralda

[antoniotiman]

If Field = '1234dddddd567'

use

mid(Field,5,6)

Regards

[alexandros17]

What is a DOB?

[#4]

Date of Birth

[alexandros17]

Give me some examples of DOB

[its_anandrjs]

what is your 13 digit no and which location DOB if it is in string then use

Right, Mid, Left for extraction

[MK_QSL · Accepted solution]

Use below line in your script instead of DOB

DATE(Date#(Left(DOB,10), 'YYYY/MM/DD')) as DOB