Changing an unput mask

  • Thread starter Thread starter Reen
  • Start date Start date
R

Reen

I want to change the way a date is entered in my database from MM/DD/YYYY to
MM/YY, how am I supposed to do that?
 
I want to change the way a date is entered in my database from MM/DD/YYYY to
MM/YY, how am I supposed to do that?
Click to expand...

A Date/TIme field is always a precise point in time. You can *display* a date
to show only the month and day, but it's still stored as a Double Float count
of days and fractions of a day since an arbitrary start point.
 
As John points out, you can store your date, but choose to format the
display (in a form, in a report) however you'd like, including "MM/YY".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Help with Date Format 4
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
DateAdd 6
convert date 1
How to change date format when using Word Mailmerge 2
Input Masks 2
Change MM/DD/YYYY to MM/DD/YY 5

Back
Top