I have a field coming from a non Access Table defined as a text field with the data formated as mm/dd/yy (08/01/05 for example). I would like to be able to convert this in a query using some sort of date function so that access can recognize it as a date field for sorting and selection criteria.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert Date in Text format to Access Date Format
- Thread starter DMHCCI
- Start date
Use the CDate function. For example, in your query, use CDate(Fieldname) rather than just Fieldname.
Be careful, however, as how it interprets the date depends on what your country settings are in your Windows. For example, 08/01/05 is 1st August in the USA, but 8th January in UK format dates.
John
Be careful, however, as how it interprets the date depends on what your country settings are in your Windows. For example, 08/01/05 is 1st August in the USA, but 8th January in UK format dates.
John
- Status
Similar threads
- Question
- Locked
- Question