HunterB
2 years ago

# Help with Creating Formula

Hello,
I have 2 fields, field 1 is a number field and field 2 is a date field from a relationship.
I would like a formula that says if field 1 =1 and it's 30 days before the date in field 2 then say complete.
but if field 1 =1 and it's 90 days before the date in field 2 then say schedule.

How would I write that in a formula?

------------------------------

### 3 Replies

• Clarify? What if it's 29 days before or 91 days before?  Your question talks about being equal to 30 days or 90 days.

------------------------------
mark.shnier@gmail.com
------------------------------
• Hi Mark,
I guess all I need is If field 2 is less than or equal to 30 days before today then mark as complete. you can forget about the 90 days one. Field 2 is a connected date field from another table not sure if that matters.

------------------------------

• The formula for a formula text field would be

IF([field 1]=1 and [field 2] <= Today() - Days(30), "Complete")

------------------------------