Date Format Issue

  • Thread starter Thread starter epete367
  • Start date Start date
E

epete367

I have a form where a user checks a check box for months desired. The
check boxes are named January...December. I need these boxes to return
the first day of that month for future shipping. For example November
should return November 1, 2005 while February should return February 1,
2006.
I thought I could use something like:
If Me.January.Value = True Then
[Forms]![frmShippingCalendar][txtJanuary].Value =
But from there I am not sure what date function/format to use.
Ultimately, this will be used to populate a shipping calendar report.
 
If Me.January.Value = True Then
Forms!frmShippingCalendar!txtJanuary.Value = DateSerial(Year(Date(), 1,
1)

The DateSerial function takes three integer numbers, for the year, month,
and day, in that order. See 'DateSerial Function' in the help file for
details.
 
Back
Top