Date Format Problem

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

I hava a database that is using alot of dates in it with different date
formats but all of the forms are requiring the date be put in with the
following format YYYY/MM/DD but it will show as the designated date format
once it is entered. Any Ideas?? THANKS IN ADVANCE!!!!
 
What do you want to change ? Your post isn't clear.....

It doesn't matter how a date is entered, ACCESS stores the date as a
double-precision number, along with the time. Formats are for display
purposes only.
 
My guess is that you actually wanted to set some InputMask rather than
Format.

Check Access Help on InputMask.
 
Back
Top