Formula Help

Question

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
------------------------------

markshnier__you · Answer

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
------------------------------

tonymiller · Answer

Sorry about that.&nbsp; I'll remember next time.&nbsp; New to using the forum.&nbsp; Thank you for the help.------------------------------Tony Miller------------------------------

tonymiller · Answer

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

tonymiller · Answer

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
------------------------------

markshnier__you · Answer

Try thisIf(not IsNull([I-INDOC Continuing Qual Date]),[I-INDOC Continuing Qual Date],AdjustMonth([I-INDOC Qualification Date], 36)-Days(1))------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Formula Help

9 Replies