ActiveX Calendar Control date - WANT MONTH TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Form currently has 2 combo boxes for (1) Promo Start Date and (2) Promo
End Date. Each combo box calls the same ActiveX Calendar so the person
entering may click a start or end date.

Based on the selection of Start Date, can I hold the 3 character month in a
different field/combo box (i.e. DEC for start dates of 12/1/04 through
12/31/04)? Similarly, I want a separate field to hold the year only (i.e.
2004)

What code will accomplish this? Thank you, cheri624
 
Format([SelectedDate], "mmm") will give you the 3 letter abbreviation for
the month, Format([SelectedDate], "mmmm") will give you the entire month
name. Format([SelectedDate], "yy") will give you the 2 digit year,
Format([SelectedDate], "yyyy") will give you the 4 digit year.
 
Back
Top