Setup Date parameter in SSRS

Hi Guys,

I have an SSRS date parameter that i need to configure or set up to
every 26th of the month i need to set this as the last day or cut off date then the succeding days will be the next mmonth..

example:
8/26/2013--'Aug-2013' cut off date

8/27/2013- start date of the month but i need to format this as 'Sep-2013'

Thanks.

JOV

  • Edited by Lenoj Thursday, August 29, 2013 6:38 AM edit text
August 29th, 2013 9:36am

Hello ,

   Not very clear on what is your ask. Please brief bit more in details for further assistance.

Free Windows Admin Tool Kit Click here and download it now
August 29th, 2013 12:47pm

I have an SSRS parameter called Ordermonth, the format is "Sep-2013" combination of month and year.

This order month will change every 27th day of the month. So on Sept 27 this will be change to "Oct-2013"

Sept 27 will be the cut off date for the month. How will i do this in SSRS?

When i tried this in my expression upon reaching the september , the result display Oct-2013 

=MonthName(Month(DateSerial(Year(Now), Month(Now)+2, 27)),3)&

"-"&Year(Today)



  • Edited by Lenoj Monday, September 02, 2013 1:15 PM addiamge
September 2nd, 2013 4:39am

This expression should get you want you need.  It calculates the date for the first of the next month and then extracts the month name and the year from it.  This will help you when you get to a new year, as well.

=MonthName(Month(Today.AddDays(1-Today.Day).AddMonths(1)),3)
& "-" & Year(Today.AddDays(1-Today.Day).AddMonths(1))

Free Windows Admin Tool Kit Click here and download it now
September 24th, 2013 1:26am

Hi Martina,

Can i have a favor to explain how this codes work? thanks.

=MonthName(Month(Today.AddDays(1-Today.Day).AddMonths(1)),3)
& "-" & Year(Today.AddDays(1-Today.Day).AddMonths(1))

February 25th, 2015 4:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics