convert report parameter and use in query

• priya06ind

  Newbie

  Points: 1

  More actions

  September 23, 2015 at 11:55 pm

  #303331

  I'm new to SSRS. I have a report parameter, which has the values like January 2015 to December 2015.

  I want to pass the parameter value as input, in the format mm/dd/yyyy,

  example: i want to change as 01/01/2015 if january is selected. Please let me know the best way to do this.

• pietlinden

  SSC Guru

  Points: 63434

  More actions

  September 24, 2015 at 12:18 am

  #1829022

  Helpful explanation. Makes thing easy!

  Note: I have a Report parameter that is of type Date (so when it runs you can pick a date from it...), it's called "prmOrderMonth"

  This should get you what you want:

  =DateSerial(Year(Parameters!prmOrderMonth.Value),Month(Parameters!prmOrderMonth.Value),1)