TonyMiller
Qrew Member
3 years ago

# Formula Help

I'm attempting to write a formula where it looks for a date in "Date 1" and if there is a date, then do a calculation.  If there is no date in "Date 1", then use "Date 2" and calculate.

I want the AdjustMonth to look in [I-INDOC Continuing Qual Date] first.  If no date is found, then use the [I-INDOC Qualification Date].

------------------------------
Tony Miller
------------------------------

### 9 Replies

• I can't edit a screen shot so in future you will receive better answers if you copy and paste your formula, but you want something like this

IF(not IsNull([my date field 1]), [my date field 1],  my formula goes here)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
• Sorry about that.  I'll remember next time.  New to using the forum.  Thank you for the help.

------------------------------
Tony Miller
------------------------------
• If([I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1)

------------------------------
Tony Miller
------------------------------
• When I try to use the formula, Is says it's looking for more.

If(not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1))

It say it's expecting ), at the end

------------------------------
Tony Miller
------------------------------
• Try this

If(
not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],