• Hi

    Thank you that was very helpfull,

    Using Expression in SSRS, how can I select Min and MAX dates?

    In other words, is it possible to do the below SQL queiry in SSRS expressoin?

    CASE DATEDIFF(dd,MIN(CONVERT(VARCHAR(10),StartDT, 101)),MAX(CONVERT(VARCHAR(10),EndDT, 101))) WHEN 0 THEN 1

    ELSE DATEDIFF(dd,MIN(CONVERT(VARCHAR(10),StartDT, 101)),MAX(CONVERT(VARCHAR(10),EndDT, 101))) AS [# of Days],

    Thanks,