Fiscal Year query

G

Guest

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query current fiscal year 2
select dates for last fiscal year 3
select fiscal year on a query 1
Fiscal year 2
Fiscal Years Query 3
Fiscal Month Query 4
Fiscal Year Query 1
End of Quarter Based on Fiscal Year 2

Top