Last year

J

John

Hi

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

Thanks

Regards
 
D

Dirk Goldgar

John said:
Hi

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


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())
 
Top