date parts

  • Thread starter Thread starter Bibi
  • Start date Start date
B

Bibi

I am designing a data base to track renovations – the user is not interested
in the date of a renovation – only the month and year – is there a way I can
store just the month and year in one date field, with the current month and
year as the default value?
TIA
Bibi
 
A date/time field must have a day. Perhaps you could use the first of the
month, and format it as mmm-yyyy.

You could put some code into the Load event of your form to set the Default
Value of a text box to DateSerial(Year(Date), Month(Date),1) or Date -
Day(Date) + 1.
 
Back
Top