6 Replies Latest reply on Dec 22, 2015 3:49 PM by fitch

    Conditions based on dates, current date is less than 30 days date in "Date Added" field.

    KenKing2551

      I am a novice with filemaker and I have been thrown into changing something in a Filemaker 10 file and I am not sure how to do something and need help.

       

      I am using a field contianing Creation date of a new record. I need to do something if the Current Date is less than 30 days from the Creation Date.

      I need to do something else if the Current Date is less than 90 days from the Creation Date and a 3rd thing if the Current Date is more than 90 days from the Creation Date.

       

      I know I need to use an IF statement but can't figure out how to set up the conditions on dates.