Using Date Function

[Ninabunny]

I am using a simple =Now() date function with the format as yyyy. Problem is this, and I know it is something simple but it is evading me!
How do I calculate that date which is this year to show last years date? =Now()-1 comes up with the day.....help!!
I know I am close...

 

[THoey]

Look at the DateAdd function. I think it is:

DateAdd('yyyy', Date(), -1) Terry M. Hoey

 

[CodeFish]

Hi Folks,

th3856 was right with DateAdd Function, but the last 2 arguements are the wrong way round. should be:-

DateAdd("yyyy", -1, Date)

Codefish

 

[THoey]

Thanks CF. I didn't go look and was going from memory. Terry M. Hoey