Post reply

Help checking date range

  • February 7, 2006 at 6:54 pm

    #170884

    I need to do this but can't find the syntax:

    IIf(Fields!EnteredDate.Value is in current month , Cint(Fields!PC.Value), CInt(0))

    I need the syntax for this for SSRS 2005 (Reporting Services)

  • February 8, 2006 at 6:27 am

    #619496

    Hope the following helps u out:

    =IIF(Format(Fields!EnteredDate.Value,"MM") = Format(Now,"MM"), Cint(Fields!PC.Value), CInt(0))

  • February 9, 2006 at 3:31 am

    #619716

    FYI... the above code will work but it assumes the dates are both in the same year.  I'd suggest validating the years as well.

  • February 9, 2006 at 7:57 am

    #619782

    Thanks a lot!

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

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