Post reply

BIDS- expression calculation

  • December 13, 2011 at 3:36 am

    #261389

    Hi all

    I am using BIDS to create a report, I have a parameter for the @startdate.

    I have added a text box in the header and in that text box I would like to add an expression to show the the @startdate + 35 days. So what ever the user selects for the start date I want the text box expression to show 35 days after the parameter selection.

    Can anyone advise on how to do this please?

    I have tried simple =(Parameters!startdate.Value +35) but I get an error "Operator '+' is not defined for type 'Date' and type 'Integer'"

    Thanks in advanced

    R

  • December 13, 2011 at 4:12 am

    #1420495

    Hi R,

    Try this =DateAdd("d",35,Parameters!YourDateColumn.Value)

    regards

    Natraj

  • December 13, 2011 at 4:14 am

    #1420496

    Perfect. THank you 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

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