Post reply

Get the oldest date in SSRS

  • August 23, 2012 at 2:32 am

    #263220

    Hi,

    I'm returing a set of date values(field). I'd like to get the oldest and latest dates from those set of dates. For example, if I have 08/01/2012, 08/05/2012, 08/31/2012 etc I need to get the oldest date as 07/01/2012 and newest date as 08/31/2012. I used Min and Max functions. But of no luck. Please help me.

  • August 23, 2012 at 3:47 am

    #1529137

    Have you tried using First and Last instead of Min and Max?

  • August 23, 2012 at 4:03 am

    #1529143

    Bear in mind First & Last are based on the sort order of the data rather than the values.

    Don't know Min/Max aren't working - what are you getting?

    Thanks

  • August 23, 2012 at 5:07 am

    #1529174

    The min and max should be working.

    Please show us your query.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

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

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