|
Posted by Twobridge on 11/29/06 01:50
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.
Navigation:
[Reply to this message]
|