Determine data within fiscal year 1

[THWatson]

Using Access 2003

A club's fiscal year is from October 1 through September 30.

To determine whether or not data falls within the current fiscal year, would the following not set the correct date parameters?

Between DateSerial(Year(Date(),9,30) AND DateSerial(Year(Date()-1,10,1))

Tom

 

[HarleyQuinn]

Pretty much, some of the parentheses are a bit out though:

DateSerial(Year(Date()[red])[/red],9,30) AND DateSerial(Year(Date()[red])[/red]-1,10,1)

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[THWatson]

Thanks, Harley

Tom

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.