jonoakley
asked on
text to date conversion
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
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
DateValue([YourTextField])
Flyster
Flyster
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CDATE return was a mess the dates were all over the map Most likely because it was reading a number and converting a number DATEVALUE return was a ERROR# in all fields
and date serial was just right.
Initially I was working on a 98 box with Access2000 and The CDATE and DATEVALUE would return a compile error
IS there a syntax to using the CDATE function to determine the position of the values?
and date serial was just right.
Initially I was working on a 98 box with Access2000 and The CDATE and DATEVALUE would return a compile error
IS there a syntax to using the CDATE function to determine the position of the values?
CDATE([MyDateField])
And
CDATE([MyDateField]) + 14