Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am trying to extract the DOB from a 13 digit identification number in qlikview.
Please HELP.
Regards
Esmeralda
Use below line in your script instead of DOB
DATE(Date#(Left(DOB,10), 'YYYY/MM/DD')) as DOB
If Field = '1234dddddd567'
use
mid(Field,5,6)
Regards
What is a DOB?
Date of Birth
Give me some examples of DOB
what is your 13 digit no and which location DOB if it is in string then use
Right, Mid, Left for extraction
Use below line in your script instead of DOB
DATE(Date#(Left(DOB,10), 'YYYY/MM/DD')) as DOB