Date Range for past dates as well as future dates

[landview]

WorkedDate is the field which stores dates upto current date agaginst Employee Time Sheet.
1- If start-date and end-date parameters are both past dates then my report will show Total Hours each employee worked in that date range and what is the (Total working days x 8)=TotalWorkingHours in that date range.(this case is working)
2- If the Start-date is the past date and end date is the future date then Report will show Total Hours each employee worked in that date range and TotalWorkingHours in that date range.(this case is working)
3-If start-date and end-date both are future dates, then the report will calculate only TotalWorkingHours in that date range.(here my record selection formula doesn't work.
My Record Selection Formula is: (CDATE({Command.WorkedDate})>={?start-date} and CDATE({Command.WorkedDate})<={?end-date})
and {Command.DeptId}={?DeptId}
and {Command.ProjId}={?ProjId}
and {Command.Name}={?Employee Name}
So, how to modify this logic so that CDATE({Command.WorkedDate})>={?start-date} or CDATE({Command.WorkedDate})<={?start-date}
Please, advice me.
Thank you.

 

[IanWaterman]

use and If ..then..else wrapped in ()

Something like

(If {?start-date} > currentdate then
.. your future date conditions else
.. your other date conditions)
and {Command.DeptId}={?DeptId}
and {Command.ProjId}={?ProjId}
and {Command.Name}={?Employee Name}

Ian