Keeping tabs on chronological data 1

[ARTH]

If I have a field where e.g someone joins, for the fist time, and I want to send an (increasingly severe)form letter to them, because they have been inactive for 30, 60 or 90 days, what is the easiest way to check this comparison IF THERE ISNT ANOTHER &quot;DATE&quot; FIELD in the table?<br><br>Thanks for reading!

 

[rochelle]

DateDiff(&quot;d&quot;, [JoinDate], Date()) will give you the number of days between the joindate and today.&nbsp;&nbsp;You can then use this value in an if or select to send out different form letters.