AnsweredAssumed Answered

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

Question asked by KenKing2551 on Dec 22, 2015
Latest reply on Dec 22, 2015 by fitch

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.

Outcomes