I am looking to determine if a transaction date occurred in the last 3 or 6 months in a straight table. The two fields are FullName and TransactionDate. I need to find the last transaction date and compare it to today's date and determine if there has not been a transaction within the last 3 months and the last 6 months or greater. How would I go about doing this?
