Date Format Problem

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!!!!
 
K

Ken Snell

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.
 
V

Van T. Dinh

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

VBA - exporting serial letters to single documents 0
Forcing a date entry format of dd/mm/yyyy 1
How to add day to PWA 2016 date format? 0
Date Formats 4
Publisher is filling blank lines with data 2
Date Maniplation 1
Space at end of multi page list to accommodate new entries 1
displaying dates in UK format 10

Top