Get the 3months back date for given date

• komal145

  SSCrazy Eights

  Points: 9918

  More actions

  November 14, 2012 at 1:39 pm

  #270902

  Hi friends,

  I am passing date value from current report to Subreport( drill through) and I have written an expression for date and My value is not passing through the main report to subreport.I dont get any error but the subreport shows blank as dat is not passing through.

  Can any one tell me the isuue?please.

  I am trying to get 1st of August month for any given day of November .I am trying to pass this date to sub report.

  = DATEADD("mm", DATEDIFF("mm", 0,@date)-3, 0)

  Here date ='11/23/2012' so I should get '8/1/2012' format

  Thanks,

  Komal

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  November 15, 2012 at 4:45 am

  #1559299

  would this help?

  http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  November 15, 2012 at 6:05 am

  #1559319

  Does this work?

  = DATEADD("mm", DATEDIFF("mm", 0,Parameters!date.Value)-3, 0)