S
Sylvia
This is similar to a previously posted question and answer, but different
enough that I need help! Our Fiscal Month begins on the 22nd of the month
and ends on the 21st. I have a Form that is used to run reports. The User
can select the month from a drop down list...this is all good. However, we
want the current Fiscal Month to be the Default Value that is automatically
displayedin this field. If the date of the month is 1 thru 21, the current
Month should be displayed. If the date of the month is 22 thru the end of
the month, the NEXT MONTH should be displayed. In the Default Value Field of
the Property Box for the Month field, this is what I have:
=IIf(Day(Date())<22,Month(Now()),(Month()+1))
The first part is working, I am testing it by changing the <22 to various
other dates, and March is displayed when appropriate, but I can't get April
to display when it should. PLEASE HELP!!!
enough that I need help! Our Fiscal Month begins on the 22nd of the month
and ends on the 21st. I have a Form that is used to run reports. The User
can select the month from a drop down list...this is all good. However, we
want the current Fiscal Month to be the Default Value that is automatically
displayedin this field. If the date of the month is 1 thru 21, the current
Month should be displayed. If the date of the month is 22 thru the end of
the month, the NEXT MONTH should be displayed. In the Default Value Field of
the Property Box for the Month field, this is what I have:
=IIf(Day(Date())<22,Month(Now()),(Month()+1))
The first part is working, I am testing it by changing the <22 to various
other dates, and March is displayed when appropriate, but I can't get April
to display when it should. PLEASE HELP!!!