Post reply

Comparing dates in an expression

  • December 19, 2011 at 7:43 am

    #252372

    Hi all

    I am currently trying to do a count on the number of entries that exist in a table that have a date greater than today. I know for a fact there should be 1, but for some reason it always generates a count of a lot more than that. I am using the following expression:

    =Count(Fields!Target_Date.Value > Today())

    Any ideas why this does not work?

    I have changed the language settings to be en-gb

    Thanks

  • December 19, 2011 at 7:56 am

    #1423114

    If you want to get it through T-sql then u can try with SQldiff() function.

    java[/url]

  • December 19, 2011 at 7:58 am

    #1423116

    I am using a Sharepoint list as my datasource so don't think I can do it that way.

    Thanks though

  • December 23, 2011 at 10:48 am

    #1425238

    This may not be relevant on your system ... on the system I work with a null date is counted as being greater than SYSDATE.

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

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