Hi, I'm trying to put together a month over month and year over year comparison report.  I have the formula fields in which to achieve this however  I am encountering a syntax problem with CloseData (see below).  Sf keeps telling me that there is no such field as CloseDate.  However Close Date is a standard field in Opportunities.

Any help would be appreciated, thanks.

CASE( MONTH ( {!CloseDate} ) , 1, "01 - January", 2, "02 - February", 3, "03 - March", 4, "04 - April", 5, "05 - May", 6, "06 - June", 7, "07 - July", 8, "08 - August", 9, "09 - September", 10, "10 - October", 11, "11 - November", "12 - December")

David

Hi, I'm trying to put together a month over month and year over year comparison report.  I have the formula fields in which to achieve this however  I am encountering a syntax problem with CloseData (see below).  Sf keeps telling me that there is no such field as CloseDate.  However Close Date is a standard field in Opportunities.

Any help would be appreciated, thanks.

CASE( MONTH ( {!CloseDate} ) , 1, "01 - January", 2, "02 - February", 3, "03 - March", 4, "04 - April", 5, "05 - May", 6, "06 - June", 7, "07 - July", 8, "08 - August", 9, "09 - September", 10, "10 - October", 11, "11 - November", "12 - December")

David