T
tim
I get a text file and link it to a Access table. I then transfer it to
another table with a text field that is a date and data is in this format:
091105. I run a query to add forward slashes:
Left$([date],2) & "/" & Mid$([date],3,2) & "/" & Right$([date],2)
The problem is I need to add 10 days to this date to be used in a merge
document. The only way I am able to do this is to change the field type to
date/time after I transfer the data and run the above-mentioned query. I
have tried changing the field type to date/time before the transfer and it
does not work. Below is part of the query I use to add 10 days to the date.
[date]+10 AS grcExpDate
What am I doing wrong?
Any help would appreciated.
Tim
Access 2000
another table with a text field that is a date and data is in this format:
091105. I run a query to add forward slashes:
Left$([date],2) & "/" & Mid$([date],3,2) & "/" & Right$([date],2)
The problem is I need to add 10 days to this date to be used in a merge
document. The only way I am able to do this is to change the field type to
date/time after I transfer the data and run the above-mentioned query. I
have tried changing the field type to date/time before the transfer and it
does not work. Below is part of the query I use to add 10 days to the date.
[date]+10 AS grcExpDate
What am I doing wrong?
Any help would appreciated.
Tim
Access 2000