Calculate Date Value in parameter

  • Hi

    I have this expression builtin in default value, Non-queried,

    =DateAdd("day",-30,Today)

    My parameter is a datetime type.

    Meaning is to have a date 30 days before today.

    I've already tried it with Now()

    In stored procedured I've used this with getdate() and it works fine.

    Anybody got any clue ?

    Thx in advance

    El Jefe


    JV

  • so ifeverything works fine then whats the problem?

  • i took it out the stored procedure so i could use multi values

    the problem was in the parameter values within my rdl.

    But it is solved now. It should be "dd" in staed of day


    JV

  • great, thats good news

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

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