ActiveX Calendar Control date - WANT MONTH TEXT

C

cheri624

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help showing active months between two dates 5
number of Full Months between dates & partial Days calculation 1
Revenue for month 0
Pass date from one form to another form in MS Access 1
separating date and time 5
Date Calculation 0
Date program calculation 3
Setting a date field using combo box 3

Top