P
pupil1966
Guest
Being very new to MSAccess, could anyone please help. I have created a database that imports a text file using the TransferText command. Everything works ok except one field is a packed 4 digit serial number and I would like to convert this to a date format field. In MS Excel I can use the DATEVALUE command. ie, if I format the cell to date type and enter the formula =DATEVALUE("02/01/1978")+ d1 - and enter a 4 digit number in cell d1, this will convert the value in the =datevalue cell to a date (this uses "02/01/1978" as a start date and adds the 4 digit number to the =datevalue.
How can I do this in MS Access ? Please supply VBA code if possible or any half decent book, or WWW site that will give the answer.
How can I do this in MS Access ? Please supply VBA code if possible or any half decent book, or WWW site that will give the answer.
