Posted by Dan on 11/29/06 09:28

I've got a simlar problem - can you post your solution?
Dan

On Nov 29, 1:50 am, "Twobridge" <Twobri...@gmail.com> wrote:
> Discovered answer on my own. Thanks anyway.
>
>
>
> Twobridge wrote:
> > Hi
>
> > I am trying to perform a search that will return records based on a
> > fiscal year search of the bill_Date. The user gives the year then I
> > want to search based on the fiscal year (July 1 - June 30) for the year
> > given. The table looks like this
>
> > Bill Table
> > id_Num bill_date bill_amount
> > 23 7/1/2005 500.00
> > 33 12/2/2005 600.00
> > 44 3/3/2006 700.00
>
> > I have tried
>
> > Select Bill.id_num, Bill.bill_date, Bill.bill_amount
> > from Bill
> > where Bill.bill_date BETWEEN 7/1/ + @year and 6/30/ + (@year +1)
>
> > Plus a variety of other fruitless concoctions....but nothing seems to
> > work. Any help would be appreciated.- Hide quoted text -- Show quoted text -

[Back to original message]