Skip to Content
0
Former Member
May 12, 2010 at 05:53 PM

How to list a calendar of billing dates.

29 Views

Hi. I have a list of communities who are billed on a monthly, quarterly, or semi-annual basis. I'd like to use the bill-cycle code to return the billing dates for "current year" for the first Monday of every month for monthly, every quarter for quarterly, every six months for semi-annual.

For instance, 2010 would look like this:

Monthly; Jan 4,

Feb 1,

Mar 1,

etc.

Quarterly; Jan 4,

Apr 5,

Jul 5,

etc.

Semi-annual; Jan 4,

Jul 5.

Does anyone have any ideas? Or how to come as close as possible to this request?

Thanks!!

Robin