Date field format

[Chad]

I was wondering if this was possible, and if so, can you
tell me how?

I have a field in one of my tables called month. I was
wondering if I could have a date/time data type and only
return the value of the month and year in the field. I
don't know if I would specify this in the input mask and
if so how I would.


Thanks for any help you can give,
Chad

 

[Jeff Boyce]

Chad

If you use a Date/Time field data type, you will store something Access
interprets as a date/time. If you want to display that as "mmmm" (a month),
you can specify that as a Format property.

Good luck

Jeff Boyce
<Access MVP>

 

[John Vinson]

I was wondering if this was possible, and if so, can you
tell me how?

I have a field in one of my tables called month. I was
wondering if I could have a date/time data type and only
return the value of the month and year in the field. I
don't know if I would specify this in the input mask and
if so how I would.

Regardless of the format, a Date/Time value is a precise instant of
time - so though you may only care about the year and month, you'll
need to store a day (perhaps the first of that month). You can set the
Format property of the field to

mmmm yyyy <November 2003>

or

mm/yy <11/03>

but the entire date will appear when you edit the field, and you'll
need to enter 1/11/03 or in some way enter the day.