Add days to date SSRS Expression

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

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 · Answer 2

Thanks!

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

Regrdas

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 3

SSChampion

Points: 13133

October 16, 2012 at 8:03 am

=DateAdd("d", 15, Now)

HTH,

Rob

davdam8 Hall of Fame Points: 3620 More actions · Answer 4

Hall of Fame

Points: 3620

October 16, 2012 at 8:19 am

Thanks

=DateAdd("d", 15, Today)

Works also

Regards