Hello.

I have a Client record with a field for Date of Most Recent Enquiry (RecentDate).

I want to track the number of clients with RecentDate between 12-24 months each month.

So I can see, for example, in May 24 we had 1000 Clients aged 12-24 months, and in  April 24 there were 1100, and so on.

I cannot figure out how you would go about doing this. I assume it would be a simple date-arithmatic calculation based on the month being displayed, but I have no idea how to do that in ZA.

thanks

Ben