How to get the most current date from a list.

[#1]

Hi All,

If I have a list of dates, lets say they are the date of every sale that a location of a business made.  How would I display the number of days since the last sale?  I understand that if I only had one date I could just use =[Sale Date]-Today() but since there are multiple dates I would want the 'most current date' - today().

So how do I create an expression to pull the most current date based on the selections of the chart?  Like for instance if I had CT and NY selected I would want to subtract 4/5/2004 from today but if I only had MA selected I would want the expression to calculate 3/4/2005 from today. 

Hope this makes sense and I appreciate the help.

Location	Sale Date
CT	12/1/2000
NY	1/2/2001
MA	1/2/2001
CT	4/5/2004
MA	3/4/2005

[maxgro · Accepted solution]

today() - max([Sale Date])

[MK_QSL]

=Interval(Today() - Max([Sale Date]),'DD')

[qlikmsg4u]

Date(today()-Max([Sale Date]))

[daniel_kusiak]

=Today()-max([Sale Date])

[#6]

Hi,

Please go through the attachment.

Regards,

Jemimah

[#7]

Hi Jemimah,

Your DATEFORMAT in the script is :  DateFormat='DD/MM/YYYY';

but the INLINE has MM/DD/YYYY.

I think the results will not be correct if format does not the match.

Regards

Kosmas