Account Schedules & Leap Year

Manjinder_Kaur

Hi

I am facing the following issue with an Income Statement, which was created using Account Schedules:

I run it for the period 010109..022809. The "Prior Year To Date" column is not including transactions for Feb 29th 08. In other words 2008 had 29 days in Feb and 2009 had 28 days.

What formula should I use in the Column layout to get all the transactions for Feb 2008?

Manjinder

Manjinder_Kaur

I see that 28 people saw my post but no one replied... :?

Please help me on this..........What date filer/Column Layout formula should I use in order to compare Year-to-Date Income Statement with same period previous year, if last Year, 2008 was a Leap Year.

The problem is I donot get transactions for Feb 29th....

Manjinder

themave

I have several account schedules and they all include 2/29/08 for the prior year

when I run the report for the current period of 2/1/09..2/28/09

the formula for comparision date formula is

-1Y

so I think the reason you don't have an answer is it works for most people

Manjinder_Kaur

Thanks......

You are right I used -1Y in the "Comparison Date Formula" and it worked!!!

Earlier I was using -1FY in the "Comparison Period Formula."

Regards,

Manjinder