Last year

[John]

Hi

How can I return last year with certainty? I am reluctant to use
Year(date()-365).

Thanks

Regards

 

[Dirk Goldgar]

Hi

How can I return last year with certainty? I am reluctant to use
Year(date()-365).

You just want to know the number of the year before the current one? So if
it's now 18 October, 2008, you want to get 2007 back? Use just

Year(Date()) - 1

If what you wanted was 18 October, 2007, then use

DateAdd("yyyy", -1, Date())