Post reply

Default value for report parameter date field

  • November 12, 2013 at 7:00 am

    #286140

    Hi,

    My SSRS report parameter date field requires “next Monday” as default Start date and “Sunday of the next week” as default End Date. Can it be accomplished using SSRS expression similar to this?

    DateAdd("d",40,Today())

  • November 12, 2013 at 7:25 am

    #1665728

    This will give you the date of the next monday (note if today is monday then today is the date returned)

    =DateAdd(DateInterval.Day,7-Weekday(Today,FirstDayOfWeek.Tuesday),Today)

    Far away is close at hand in the images of elsewhere.
    Anon.

  • November 13, 2013 at 2:22 am

    #1665959

    Thanks David, for sharing that insight.

    I have put the end date default date as:

    =DateAdd(DateInterval.Day,14-Weekday(Today,FirstDayOfWeek.Monday),Today).

    I hope it is correct.

  • November 13, 2013 at 2:52 am

    #1665966

    For your end date I think it should be

    =DateAdd(DateInterval.Day,6,DateAdd(DateInterval.Day,7-Weekday(Today,FirstDayOfWeek.Tuesday),Today))

    Far away is close at hand in the images of elsewhere.
    Anon.

  • November 14, 2013 at 3:55 am

    #1666318

    Thank You, David once again. Let me try it out.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply