I would like the appropriate option to be selected based on the current date. I was thinking that there would be an easy way to do this, I can't find it.
IF DATE >= "April 1" AND <= "June 30" THEN ???(Option 1 would be defaulted)
ELSEIF DATE >= "July 1" AND <= "September 30" THEN ???
ELSEIF DATE >= "October 1" AND <= "December 31" THEN ???
ELSE ???
END IF
<SELECT NAME="reportingperiod">
<OPTION VALUE=1>Apr 1 - Jun 30</OPTION>
<OPTION VALUE=2>Jul 1 - Sep 30</OPTION>
<OPTION VALUE=3>Oct 1 - Dec 31</OPTION>
<OPTION VALUE=4>Jan 1 - Mar 31</OPTION>
</SELECT>
Thank you!
IF DATE >= "April 1" AND <= "June 30" THEN ???(Option 1 would be defaulted)
ELSEIF DATE >= "July 1" AND <= "September 30" THEN ???
ELSEIF DATE >= "October 1" AND <= "December 31" THEN ???
ELSE ???
END IF
<SELECT NAME="reportingperiod">
<OPTION VALUE=1>Apr 1 - Jun 30</OPTION>
<OPTION VALUE=2>Jul 1 - Sep 30</OPTION>
<OPTION VALUE=3>Oct 1 - Dec 31</OPTION>
<OPTION VALUE=4>Jan 1 - Mar 31</OPTION>
</SELECT>
Thank you!