|
Posted by Twobridge on 11/29/06 01:30
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]
|