Extracting usefull data from South African ID number

Extracting usefull data from South African ID number

I want my client to be able to input their RSA ID number (it's a bit like the American social security number) into a field, and have the information in the number used to autocomplete other fields in the same form.

South African ID numbers contain info on: Date of Birth (and therefore age) as well as gender.

If one of you Zoho Creator Superstars can show me how to have the Date of Birth field autocompleted after the client fills in his RSA ID number; I'm sure I can do the rest myself.

The first six digits of a 13 digit RSA ID number indicates the date of birth. So, for example, in an ID number like 7702081238970; the first six digits (770208) show that this person was born 8 Feb 1977. I would want my app to be able to take those six digits out of the RSA ID number and then turn them into the relevant date of birth.

Reckon you can help?