Forum Discussion

TonyMiller's avatar
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
------------------------------
Formulas and functions

9 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    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's avatar
      TonyMiller
      Qrew Member
      3 years ago
      Sorry about that.  I'll remember next time.  New to using the forum.  Thank you for the help.

      ------------------------------
      Tony Miller
      ------------------------------
    • TonyMiller's avatar
      TonyMiller
      Qrew Member
      3 years ago
      If([I-INDOC Continuing Qual Date],(AdjustMonth([I-INDOC Qualification Date], 36)-Days(1)

      ------------------------------
      Tony Miller
      ------------------------------
    • TonyMiller's avatar
      TonyMiller
      Qrew Member
      3 years ago
      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's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        Try this


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