What is the easiest way to force Access to read a date in a specific
format?
I have an application that imports a delimited text file with a date
field in the format "mm/dd/yyyy".
I've written a function that converts it to a numeric date (integer)..
and it's quite a long, convoluted function (it converts it to a medium
date in the process). This may seem completely insane, but it was the
only way I could think of to ensure that Access reads it properly.
(Access can never seem to make up it's mind whether it wants to read a
date as mm/dd/yy or dd/mm/yy - I don't trust CVDate).
Any thoughts on a more efficient function that would perform the same
task?