MorningSun
Technical User
I would like to have a drop down box on a form that allows a user to select Month,Year (October,2005). With the datepicker, you have to select a day... which is irrelevant in my case. I just need month and year but don't want to type the values for the combobox in for an infinite period of time. Is that possible?
Also, if I have this drop down box set to default to the current date: =format(date(),"mmmm,yyyy"), how do I subtract a month from that? I want the form that they enter data on to automatically populate with the previous month and THEN also have it as a combobox so they can select the correct month & year if the previous month is not the one they want to enter data for...
Is this possible?
Thanks so much!!!!
Dawn Coleman, Business Analyst
UnumProvident Corporation
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.
Also, if I have this drop down box set to default to the current date: =format(date(),"mmmm,yyyy"), how do I subtract a month from that? I want the form that they enter data on to automatically populate with the previous month and THEN also have it as a combobox so they can select the correct month & year if the previous month is not the one they want to enter data for...
Is this possible?
Thanks so much!!!!
Dawn Coleman, Business Analyst
UnumProvident Corporation
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.