Defining Quarterly "dates" in a report
Posted on 2005-04-26
[A] I have a report that I normally prepare every three months by typing the following dates
using "date range" - instead of typing these dates.
01/01/05 - 03/31/05 Qtr 1
04/01/05 - 06/30/05 Qtr 2
07/01/05 - 09/31/05 Qtr 3
10/01/05 - 12/31/05 Qtr 4
I 'll like to just pick the appropriate Quarter and print the report on a yearly basis. In other words in 2006, Qtr1 , Qtr 2, Qtr 3, Qtr 4 will simply be selected and the report printed.
[B]. The current date format for the date each report is printed is: =Format(Date(),"Short Date")
I'll like to change this date to change such that new format would be each quarter plus 1
for instance if printing quarter1, then date report is printed should be:
"Qtr 1 + 1 = 04/01/05
If the date falls on a weekend or on a holiday (DlookUp tblholiday) and insert the next business date