Ok, so the data is a text file. Now the first two digits represent the year if the digits are before 10 then one the user can assume that the year range is 1910 to 1999. Before 10 then the date range is 2000 to 2009. How would you code a person who is 100 years and older i.e. born before 1910?
Using your example actual data input : 791011125739 is this entered on a form and where do you want the Date of Birth and Gender/Sex displayed or stored?
Pro, sorry for asking ur help too much, but, i am lack of knowledge with vba; but i understand what it does. i love vb, cos' i've done great things with ms access. All hard coded on my current project taken from various site, but, still, i can't write the code my self.
This is an add on with the current ID_Patient code.
Let me begin with :
Patient ID = 891009125859
'I would like to extract only the last 4 digit = 5859
'then reformat it (txtReformat_1) to be = 9585
With this data, 5859 ; i need to rereformat it to another single data (display only),
Case 1 = 891009125859 (from ID_Patient)
'extract last 4 digits to txtReformat_1 (display only)
Case 2 = 5859 (txtReformat_1)
'reformat data case 2
Case 3 = 9585
'extract data into 3 seperate data to txtModified
txtModified_1 = 5
txtModified_2 = 8
txtModified_3 = 59
'Read from right to left.