Month and Day Date Selection

Hi Folks:

I'm running a query whereby my users will select between "FromCloseDate" and "ToCloseDate". The easy part is when they're searching for month, day and year between the close dates however, they have a boolean report parameter that allow them to select month and day between the close dates. Has anyone done a between date selection for month and day?

Thanks in advance

Couldn't you just use the MONTH() and DAY() functions to extract the month and day for use in your query? Or you could use SUBSTRING().

MOM & SQL Monitoring

Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
AngelinaThis is your starting point: http://www.microsoft.com/mom/
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1116901c3f53f$92e65820$a301280a@.phx
.gbl...
Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
Angelina|||Thanks Narayana,
Done that. I'm looking for specifics on how monitoring
can be setup for SQL Server. Just trying to cut down the
chase.
Thanks,
Angelina
>--Original Message--
>This is your starting point:
http://www.microsoft.com/mom/
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Angelina" <anonymous@.discussions.microsoft.com> wrote
in message
> news:1116901c3f53f$92e65820$a301280a@.phx
.gbl...
>Does anyone know the Microsoft SQL site whereby I can
>collect information regarding using Microsoft Operations
>Manager to Monitor SQL server..
>Thanks,
>Angelina
>
>.
>

MOM & SQL Monitoring

Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
AngelinaThis is your starting point: http://www.microsoft.com/mom/
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1116901c3f53f$92e65820$a301280a@.phx.gbl...
Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
Angelina|||Thanks Narayana,
Done that. I'm looking for specifics on how monitoring
can be setup for SQL Server. Just trying to cut down the
chase.
Thanks,
Angelina
>--Original Message--
>This is your starting point:
http://www.microsoft.com/mom/
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Angelina" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1116901c3f53f$92e65820$a301280a@.phx.gbl...
>Does anyone know the Microsoft SQL site whereby I can
>collect information regarding using Microsoft Operations
>Manager to Monitor SQL server..
>Thanks,
>Angelina
>
>.
>