10 Replies Latest reply: Jul 26, 2016 2:02 AM by Gysbert Wassenaar RSS

    Date functions within a straight table

    Cliff Clayman

      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?