Add days to date SSRS Expression

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  October 16, 2012 at 4:14 am

  #268557

  Hi geniuses,

  How do I add days to a date in an expression.

  Field: payment_date

  and I want to add 15 days to that date

  Thanks!

  Regards

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 16, 2012 at 6:13 am

  #1549504

  In the Expression editor, under the Common Functions in the Category window look at the Date & Time functions. Use the DateAdd() function.

  =DateAdd("d", 15, Fields!payment_date)

  HTH,

  Rob

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  October 16, 2012 at 7:02 am

  #1549527

  Thanks!

  And If I want to add 15 days to todays date?

  Regrdas

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 16, 2012 at 8:03 am

  #1549583

  =DateAdd("d", 15, Now)

  HTH,

  Rob

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  October 16, 2012 at 8:19 am

  #1549600

  Thanks

  =DateAdd("d", 15, Today)

  Works also

  Regards