That works brilliantly.
For some reason comments are not comming up on this post for me, but I did get the email notification.
When it comes up I'll select it as the best answer. Thanks again
P.S. this one seems to come up as an answer, so for the benifit of others, this was Nick's reply. Thanks again Nick.
posted 9:33 AM by sunmoonstar_13
In your customers table, create an unstored Calculation field (call it, say, Date_mark ) with this calculation:
Case ( Helpdesk::Just_Date ≤ Get ( CurrentDate ) and Helpdesk::Just_Date ≥ (Get ( CurrentDate ) - 30) ;1 )
Then create a Summary field: Summary = Count ofDate_mark
The Calculation field returns a value of 1 if the Case statement is true and then the Summary field simply counts those records "marked" with the value of 1.
I deleted my comment, because after thinking about it, I wasn't 100% sure that Helpdesk::Just_Date was the right table & field to use, but based on your response, I gather it was!