Forum Discussion

DIPAPANCHALL's avatar
DIPAPANCHALL
Qrew Member
3 years ago

Formula Help

Hello,

I am trying to create a date/time formula field and am getting stuck. I want the date/time field to refer another date/time field and if it's equal to 01-01-1970 then I do not want the date to show but if isn't equal to 01-01-1970 then I want the date to show. I keep getting an error for operator = cannot be applied to types date, text.
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Can you post  a copy paste of your formula and the error?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • DIPAPANCHALL's avatar
      DIPAPANCHALL
      Qrew Member
      3 years ago
      Below is the formula. So if "JA Target Completion is = to "01-01-1970" I do not want the date to show, if it's not equal to "01-01-1970" then I want it to show.

      If([JA Target Completion Date] = "01-01-1970" null, "")

      ------------------------------
      DIPA PANCHALL
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        All of these should work

        If([JA Target Completion Date] <> ToDate("01-01-1970"), [JA Target Completion Date])
        If([JA Target Completion Date] <> Date(1970,1,1), [JA Target Completion Date])
        If([JA Target Completion Date] = ToDate("01-01-1970"), null, [JA Target Completion Date])
        If([JA Target Completion Date] = Date(1970,01,01), null, [JA Target Completion Date])

        My favorite is this one

        If([JA Target Completion Date] <> Date(1970,1,1), [JA Target Completion Date])

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------