text to date conversion
Posted on 2006-03-31
I have linked an external DBF file. Within that DBF is a date field that Access sees as a text field. The format is MMDDYY
I want to add that field to a query WHERE value is BETWEEN January 01of the current year and Current date +14
When I use #010106# Access automatically quotes it as text.
How can I make access treat this is a date field? Then how do i use this to reflect a set future date say DATE() +14