Comparison Date Formula

sabzam

Dear All,

I have got an issue with the Sales Analysis Report. I need to create a column which looks back to the previous year. I've tried to use the Comparison date formula but when having a period stating 1 year for example 010112..311212 it does not go back to the whole year but instead to the first month of that year. Therefore I require the period 010111..311211 but instead I obtain 010111..310111.

Has anyone got any clue why this may be happening?

Thanks in advance.

jem_ski12

Date format should be mmddyy to get the range. if you want to get the jan. 1 2011 to dec. 31 2011, then this is the format 010111..123111