financial year

P

Phil

how do i get access to only return results within the financial year (April -
march), i have a field registrationDate which is where i would presume the
criteria would be based. i would want the query to automatically change with
each year so in 2005/06 it would display the 2005/06 results however in
2006/07 it would be 2006/07 results

thanks for any help

Phil
 
K

KARL DEWEY

This will convert your dates to financial years.
DatePart("yyyy",DateAdd("m",-3,[YourDate]))
Just enter a four digit year as criteria.

This will give you the current financial year.
DatePart("yyyy",DateAdd("m",-3,Date()))
 
P

Phil

Karl thanks a lot that worked great

Phil

KARL DEWEY said:
This will convert your dates to financial years.
DatePart("yyyy",DateAdd("m",-3,[YourDate]))
Just enter a four digit year as criteria.

This will give you the current financial year.
DatePart("yyyy",DateAdd("m",-3,Date()))


Phil said:
how do i get access to only return results within the financial year (April -
march), i have a field registrationDate which is where i would presume the
criteria would be based. i would want the query to automatically change with
each year so in 2005/06 it would display the 2005/06 results however in
2006/07 it would be 2006/07 results

thanks for any help

Phil
Click to expand...
Click to expand...
 
Top