Good day, new to SSRS and working on a report that will pull monthly data into it. I was trying to create a parm where the user would select "January", "February", "March" etc and it will pull data for that month. In the parm, I always want to start the date with 1/1/current year, 2/1/current year where current year is dynamically chosen based on Now(). I tried a few things and nothing worked. =CDate("1/1/" + Year(Now())) for each month but gives me conversion errors etc. Looking for some assistance in creating an expression where i can set the month, first day of month, and dynamic year. Our company has used a report like this for years and it won't go away, but every year at the end of year our payroll admin goes in and updates the year, for all reports taking some considerable time. In addition, is there anyway i can default that parm to the current month (i.e. user pulls report up and it defaults to Feb as opposed to 1st parm or Jan in this case? Thanks in advance for any assistance, again new to this as we are moving reporting platforms (BO to MS) and I was asked to get involved.

hello, you the '&' operator for string concatenation so try this: =CDate("1/1/" & Year(Now()))

Thanks NW