DTE Date Format Help needed

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have a field in my table called DTE, it is date field with a short date
format.
on my form i want the field to only show or allow a input date of month and
year
month being formatted as 08 for september and year as 04, not 2004???
08/04

Thanks,


Dave
 
I have a field in my table called DTE, it is date field with a short date
format.
on my form i want the field to only show or allow a input date of month and
year
month being formatted as 08 for september and year as 04, not 2004???
08/04
Click to expand...

An Access Date/Time value is a date, a precise point in time.
September 2004 is not a date - it's thirty of them!

I would suggest using a Text field with an Input Mask of 00/00, or two
Integer fields for the month and year, instead. If you really want to
use a date/time field, set its Format property to mm/yy; you will need
to enter a full date (e.g. 9/1/04) but it will display as 09/04.

John W. Vinson[MVP]
 
Back
Top