Example: Calculating Forecast Planning Dates

Monthly calculations assume that any given month starts the day after the prior month ends. Likewise, any given month ends the day before the next month starts. A month's end date can be calculated by determining the start of the next month and backing up one day.

Weekly calculations assume that any given week ends six days after it began. Likewise, any given week starts six days before it ends.

When you use the calendar or week calculations with beginning and end date rules, this table describes the possible scenarios:

Heading 1	Heading 2
Calendar Month, Calculate Month End Date	You use the calendar month and receive the month begin date from the customer. The system calculates the month end date as the last day of the calendar month.
Calendar Month, Calculate Month Begin Date	You use the calendar month and receive the month end date from the customer. The system calculates the month begin date as the first day of the calendar month.
Calculate Occurrence Month, Calculate Month End Date	You base the beginning date on a day of the week and the occurrence of that day in the month. You receive the month beginning date from the customer. The system calculates the month end date by finding the next month's beginning date and backing up one day.
Day Occurrence, Calculate Month Begin Date	You base the ending date on a day of the week and the occurrence of that day in the month. You receive the month ending date from the customer. The system calculates the month begin date by finding the prior month's end date adding one day.
Anchor Month, Calculate Month End Date	You base the month on a day-of-week anchor and receive the month beginning date from the customer. The system calculates the month end date by finding the start of the next planning month and backing up one day. The system calculates the next planning month's beginning date by finding the start of that calendar month and locating the first occurrence of the anchor day of the week.
Anchor Month, Calculate Month Begin Date	You base the month on a day-of-week anchor and receive the month ending date from the customer. The system calculates the planning month's beginning date by finding the start of the calendar month and locating the first occurrence of the anchor day of the week.
Week Date Range	You use weekly beginning and ending dates. The system adds six days to determine the end date or subtracts six days to determine the beginning date.
Fiscal Date Pattern Month, Calculate End Date	You use the received date with the fiscal date pattern to determine the end dates, based on the values established in the fiscal date pattern for that period. In this case, the system uses the last day of the fiscal period as the ending date.
Calculate Fiscal Date Pattern Month, Calculate Begin Date	You use the received date with the fiscal date pattern to determine the beginning dates, based on the values established in the fiscal date pattern for that period. In this case, the system uses the first day of the fiscal period as the beginning date.