In the above solution th e "<=" by adding one more day we will not be able to use the "=" sign. Do you think this might work:

Select max(fromdate)...

Thanks paul!!  that helped, as I will be comapring date datatype with datetime variable.

-SD