Fiscal Year query

C

Cyberwolf

OUr fiscal year runs May - April. I need to create a report that spans
multiple fiscal years. The actual month or day is not important, just the
year. How can I build statement that looks at a date field and determines
that anything that falls between "05/01/02" and "4/30/03" is consider 2002
and so forth.
 
C

Cyberwolf

That was exactly what I was looking for.

Thanks

KARL DEWEY said:
Try this --
DatePart("yyyy",DateAdd("m",-4,[YourDate]))

Cyberwolf said:
OUr fiscal year runs May - April. I need to create a report that spans
multiple fiscal years. The actual month or day is not important, just the
year. How can I build statement that looks at a date field and determines
that anything that falls between "05/01/02" and "4/30/03" is consider 2002
and so forth.
Click to expand...
Click to expand...
 
Top