how to calculate givendate is before last sunday of the month or after the last sunday of the month

here is similar thread might help you http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125258

---

http://uk.linkedin.com/in/ramjaddu