Date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For a date like "Jan-08" I have the format set to "mmm/yy". What input mask
do I need?

cheers
 
scubadiver said:
For a date like "Jan-08" I have the format set to "mmm/yy". What
input mask do I need?

cheers
Click to expand...

You need no Input Mask at all. Formatting is about display and Input Masks are
about controlling input.

Note that Jan-08 is NOT a date. A proper date needs a day value. You can use
formatting to suppress the display of the day, but the day must still be there
in the underlying value.
 

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

Date format automatically changed 1
Access 2003 Date Input problem 3
Combo box date format 3
Entering and Viewing dates in a form 5
Combo box date format changes when item selected from list 4
Date Format Code 3
add one day to input date? 4
Access General Date Forced To Have Date And Time 2

Back
Top