Defaulting a Parameter Date to Saturday of the week !

• girish_skivor

  Grasshopper

  Points: 23

  More actions

  December 19, 2017 at 11:22 pm

  #402769

  Hello guys,
  I need to default any date chosen from the date picker in SSRS to Saturday of current week. Logically it needs to check which day it is and add the remaining days so that the final date value is a Saturday. I tried the following but did not work :

  =iif(Weekday(Parameters!fdate.Value)<7,Parameters!fdate.Value=DateAdd("d", 7 - Weekday("wd",Parameters!fdate.Value) , Parameters!fdate.Value)

  Your help would be much appreciated.

  Thanks & Regards,
  Girish.

• girish_skivor

  Grasshopper

  Points: 23

  More actions

  December 20, 2017 at 12:51 am

  #1972845

  Hi Guys,

  In fact, the report should load with a default Saturday of the week. So i managed to get the correct syntax for the code:

  =iif(Weekday(Today())<7,DateAdd("d", 7 - (Weekday(Today())),Today()),Today())

  Hope this helps.

  Regards,
  Girish