Not quite sure what you mean but there are functions such as 'previous' that might suit. You could also work out the most recent date in the script using max in the load statement:
Load [Contract No], date(max([Last Income])) as [Last Income] resident [tLast Income] group by [Contract No];
What I am trying to achieve, is within a gauge chart, show the last record in the system. So all my records have a date, but not all nessessary are from yesterday, or a week ago, the recent one might from a year ago... But I want to pick the most 'recent' record, just not sure how to go about it.
