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?
------------------------------
Qrew LegendClarify? What if it's 29 days before or 91 days before? Your question talks about being equal to 30 days or 90 days.
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.
------------------------------
Qrew LegendThe formula for a formula text field would be
IF([field 1]=1 and [field 2] <= Today() - Days(30), "Complete")
