I am pulling employee information from an Access2000 DB! In the table that I need the info from, the DOB, HireDate, ect are not entered as one date field. They are entered as three text fields. Like:
BirthDate Month
BirthDate Day
BirthDate Year
Is there a way to combine these fields in ASP so that I would see the following:
If in the DB it was:
BirthMo was 4
BirthDy was 10
BirthYr was 1971 (year is "yyyy"
I would see:
4/10/1971 or 4/10/71 on the ASP?
I am new to ASP, so any advice would be greatly appreciated!
Thanks in advance!
Smitty
BirthDate Month
BirthDate Day
BirthDate Year
Is there a way to combine these fields in ASP so that I would see the following:
If in the DB it was:
BirthMo was 4
BirthDy was 10
BirthYr was 1971 (year is "yyyy"
I would see:
4/10/1971 or 4/10/71 on the ASP?
I am new to ASP, so any advice would be greatly appreciated!
Thanks in advance!
Smitty