Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
today() - max([Sale Date])
today() - max([Sale Date])
=Interval(Today() - Max([Sale Date]),'DD')
Date(today()-Max([Sale Date]))
=Today()-max([Sale Date])
Hi,
Please go through the attachment.
Regards,
Jemimah
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