Expression help

[danielnevitt]

Hi,

I am trying to create an expression which returns the bl_dt when I have a max modify_dt.  Is that possible?

If so, any help would be much appreciated.

Regards,

Daniel

[MK_QSL]

Provide some more information..

[swuehl]

Should / could be possible. Maybe use FirstSortedValue():

=FirstSortedValue(DISTINCT bl_dt, -modify_dt)

modify_dt needs to have a numeric representation.

[danielnevitt]

Hi Manish,

Suppose I have the following data:

Modify_Dt          Bl_Dt

01/02/2016        10/02/2016 

02/02/2016        11/02/2016

03/02/2016        12/02/2016

04/02/2016        13/02/2016

I would like to create an expression that calculates the max Modify_Dt as 04/02/2016 and then returns 13/02/2016.

The next step is to take that result and show the differences between the date and today.

Hope that makes sense.

Regards,

Daniel