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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
displaying dates in UK format 10
Date field not stay in same format 1
Format a Date Text Box As 2010-02-28 3
Date calculations - please tell me where I am going wrong 2
Medium Date format and calendar in Access 2007 1
MM/YYYY Input format 2
Date formating. 6

Back
Top