Access SQL handles dates as mm/dd/yyyy hh:mm:ss

The Access DB I'm dealing with requires dates to be stored in a text format of YYMMDDHHMMSS:

I need to Query dates from the previous day and a timestamp value to today and a timestamp value.

For example: BETWEEN 7/23/2008 12:00:00 PM and 7/24/2008 11:11:59 AM

----------------------------------------------

On thought was to create another date column and when the YYYYMMDDHHMMSS is entered convert the date to the normal SQL query format.

Other than that anyone have a suggestion on the best way to accomplish this date query?