How do I create a month/year date input mask in Access?

G

Guest

I can't get input mask to let me create a month/year date; it will only make
a month/day/date not matter how I change the mask. Is there any way around
this?
 
J

John Vinson

On Wed, 16 Mar 2005 12:01:02 -0800, "CA KARL" <CA
I can't get input mask to let me create a month/year date; it will only make
a month/day/date not matter how I change the mask. Is there any way around
this?
Click to expand...

An Access Date/Time field is not stored formatted: it's stored as a
double float count of days and fractions of a day (times) since
midnight, December 30, 1899. As such a Date/Time value corresponds to
a precise moment of time - NOT to an entire month. March 2005 isn't a
date - it's about thirty-one different ones! <g>

I'd suggest storing your month-year (credit card expiration maybe?)
data in a Text field instead with a 00/00 or (probably better) 00/0000
mask.

John W. Vinson[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

Date Input Mask Question 4
Month Year Date Format 3
Creating Custom MS-Access Input Masks 0
Properties - Format, Input Mask, Validation Rule 5
need date to show as 2005/10/05 2
Input Mask for General Date/Time 1
Input mask for date! 0
Input mask for date field -- year only 4

Top