SSRS Date Time Experession

• bharat3k-792122

  Newbie

  Points: 1

  More actions

  November 21, 2008 at 10:11 am

  #203122

  Hello Everyone,

  I am using SSRS for some reports and one of my report which get report based on parameters has start date and end date as parameter. not , I have wirtten an expression , with which if user put today date, the expression would add one more day to it.

  Now my issue is, if I want to subtract just one sec from this day and track the details before that day. what should I do.

  This is my present expression:

  = Format(DateAdd("d", 1, Parameters!rsThruDate.Value), "dd-MMM-yyyy")

  any help would be greatly appreciated.

• Will Riley

  Ten Centuries

  Points: 1030

  More actions

  November 21, 2008 at 12:53 pm

  #901852

  try this

  = Format(DateAdd("s", -1, Parameters!rsThruDate.Value), "dd-MMM-yyyy")

  Kind Regards, Will

• Will Riley

  Ten Centuries

  Points: 1030

  More actions

  November 21, 2008 at 12:55 pm

  #901854

  or did you mean this

  = Format(DateAdd("s",-1,DateAdd("d", 1, Parameters!rsThruDate.Value)), "dd-MMM-yyyy")

  Kind Regards, Will