|
| Hi
Use this query
Select * from <your table>
Where Month(TDate)=5 and Month(FDate)=5
Regards
Rags
>-----Original Message-----
>Hi All
>
>I have a tricky question wonder if anyone can help.
>
>I store dates in my table as
>
>FDate TDate NoDays
>
>
>Where Fdate is From Date
>TDate is To Date
>NoDays is number of days.
>
>We use this to record holidays for our employees.
>
>I would like to write a SQL query which will display all
the records where
>Fdate or Tdate are within the current month. Not very
good at writing SQL
>hence need some help.
>
>Some sample data can be like this
>
>Fdate TDate NoDays
>15/05/04 18/5/04 4
>29/04/04 2/5/04 5
>29/5/04 3/06/04 4
>
>If that was the data in the my table and running this
query I would expect
>it include all the three records when searching for month
of "May" as all
>three records have atleast one day which falls in the
month of May
>
>thanks for your help
>
>Jas
>
>
>.
>
|
|