13 Months Before Calculation 1

[lewes]

Hi, I'm using CR9.

Does anyone know what I could put in a formula to automatically calculate the first day of 13 months before. For example if today's date is 11 April 2008, I want the result to be 01 April 2007.

I'd be grateful for any help.

Thanks

 

[MJRBIM]

What do you want to happen on May 1 2008?

Do you still want April 1 2007 - or May 1 2007?

 

[lewes]

Hi MJRBIM,

In answer to your question for May 1 2008, I want May 1 2007.

Thanks

 

[kskid]

Try this

dateserial(year(currentdate)-1,month(currentdate),1)

-lw

 

[lewes]

Thanks kskid this worked perfectly. I even managed to adjust it so it picks the last day of the month aswell.

L