I have a report in SRSS where a user selects a @startdate and @enddate and so produces their required output. The dates selected are always a full calendar month so October would be 1/10/2013 to 31/10/2013. There seems little point in doing this so a drop down of months and another for year would be preferential. I know I can create parameters and provide values say Jan Feb, Mar and 2012,2013, etc. but how do I format the query
FA_ACCOUNTS.FA_BOUGHTDATE = ?????
Bought date is date\time