Post reply

I'm trying to get my ssrs report to display the differences between two dates

  • June 20, 2012 at 7:47 am

    #262605

    = iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today())

    I'm trying to get my ssrs report to display the differences between two if less than 60 days in the first colum

  • June 20, 2012 at 8:05 am

    #1503450

    The part you missed is the false part of when the date diff is not <60

    = iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today()), "Date not less than 60")

    gsc_dba

  • June 20, 2012 at 8:08 am

    #1503455

    It doesnt like the <

    = iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today()), "Date not less than 60")

  • June 20, 2012 at 9:31 am

    #1503542

    lcarrethers (6/20/2012)

    It doesnt like the <

    = iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today()), "Date not less than 60")

    Instead of using 60 (integer) try using DateAdd(DateInterval.Day,-60,Now())

    I also got an error because the int cannot be compared to date

    gsc_dba

  • June 20, 2012 at 9:34 am

    #1503548

    It didn't like the <

    I replaced it with < and it worked.

  • June 20, 2012 at 9:36 am

    #1503550

    Nevermind, it came over as <

    as &lt not <

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

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