Format(Date, "yy") - 1) (1 Viewer)

[Haynesey]

Hi,

I need to use the following code to present the previous year (2006 for example) in the format 06. However, the code misses the 0 off the front.

Format(Date, "yy") - 1)

Any ideas?

Thanks

Lee

 

[boblarson]

Format(DateAdd("yyyy", -1, date), "yy")

 

[Haynesey]

Thanks that worked great!

Cheers

Lee

 

[ted.martin]

I was going to say knock off 365 days

 

[llkhoutx]

Format(DateAdd("d", -365, date), "dd") or something like that. The year subtracting is better.

There are numerous date manipulations and functions. If you don't find what you want on this forum use Google.