?? on adding a day to a dataset filter date

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  July 22, 2014 at 12:59 pm

  #397097

  Hi

  I have a two date parameters (StartDate and Enddate)

  I want to filter dataset1 by Startdate thru Enddate + 1 Day , I tried enddate value as =DATEADD("D",Parameters!EndDate.Value,1)

  But errors ...

  Any ideas would be great

  Thanks

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  July 23, 2014 at 7:47 am

  #1731756

  I finally figured it out...

  I'm using =CDate(Format(Parameters!EndDate.Value, "yyyy-MM-dd" & " 23:59:59")) which gives me the end date @ 23:59:59