Rob Wunderlich has created a good application to handle date ranges, where he creates a simple calendar and creates date ranges which you can modify according to what you want.
An advice: You asked for sysdate, which is retrieved here by the today() function. In practice, especially if the application is not reloaded every day, the reload time is more relevent than the curent date. If this is the case, just replace today() with the ReloadTime().
