Post reply

SSRS format getdate

  • March 17, 2011 at 10:06 am

    #248447

    Hello,

    I have a requirement to display data on an SSRS report based on ARRIVAL_ESTIMATE_DT column which is calculate data based on when ARRIVAL_ESTIMATE_DT is equal to getdate -7 and getdate +14 days.

    Does someone know how to achieve this ?

    Thanks and Regards,

    Paul

  • March 17, 2011 at 12:17 pm

    #1300141

    I would probably make 2 parameters, BeginRange and EndRange, (hidden or internal I am not sure what your needs are). Then set the default value for each parameter to the appropriate range value. Then take those 2 parameters and put them in the where clause of your primary dataset query

    WHERE ARRIVAL_ESTIMATE_DT BETWEEN @BeginRange AND @EndRange

  • March 18, 2011 at 6:38 am

    #1300451

    Daniel Bowlin (3/17/2011)

    I would probably make 2 parameters, BeginRange and EndRange, (hidden or internal I am not sure what your needs are). Then set the default value for each parameter to the appropriate range value. Then take those 2 parameters and put them in the where clause of your primary dataset query

    WHERE ARRIVAL_ESTIMATE_DT BETWEEN @BeginRange AND @EndRange

    Thanks a lot, Daniel !!! Your reply was quite helpful.

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

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