easy date format question 1

[LloydDobler]

at least i hope it's easy. I want to display the year as a column heading in a report, only I need to display the current year, last year, and 2 years ago. Is there a format that can do this? I've tried =Format((Now(), "yyyy")-1) but that doesn't seem to work.

Any help is much appreciated.

"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."

 

[Remou]

How about:
=Year(Now())-1

 

[SkipVought]

Hi,

FYI, the reason that your Format approch did no work is that the Format function returns TEXT.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[LloydDobler]

remou, that did it thanks. Probably one of the easier starts you'll earn! I could swear I tried that, but maybe I used getdate() instead without thinking. Skip, thanks for the format lesson!

"I don't want to sell anything, buy anything or process anything as a career. I don't want to sell anything bought or processed... or buy anything sold or processed... or process anything sold, bought or processed... or repair anything sold, bought or processed. You know, as a career, I don't want to do that."