Post reply

Exclude dates with specific time 23:59:59.990

  • August 25, 2015 at 2:17 pm

    #311104

    Hi

    I am looking to hide lines where the time portion of datetime is "23:59:59.990"

    Any advice would be very much appreciated

    Thanks

    Joe

  • August 25, 2015 at 3:27 pm

    #1822340

    I would set the row filter property on your table (or the row hidden property) to the expression

    =TimeSpan.Parse("23:59:59.990") = CDate(Fields!item.Value).TimeOfDay

    That is easy to read, and shouldn't be too bad performance-wise.

    An alternative could be =CDate(Fields!item.Value).ToString("hh:mm:ss.fff") = "23:59:59.990" but converting to string to do the comparisons doesn't look proper.

    If those solutions look like they'd work but you need more details I could give more detailed instructions.

  • August 26, 2015 at 7:28 am

    #1822467

    This info is great..

    Thanks so much

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

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