>Ok. How would I use DATEDIFF in the following SQL? I want to test to
>see if a specified date falls in a certain range of dates
>
>
>

>SELECT *;
> FROM MyTable;
> WHERE BETWEEN(MyDate, dStartDate, dEndDate)
>

>

of course, dStartDate, dEndDate are metadata

SELECT *;
 FROM MyTable;
 WHERE datediff(d,dStartDate,getdate()) 
            between 0 and datediff(d,dStartDate,dEndDate)