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 ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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
    ------------------------------
    • DIPAPANCHALL's avatar
      DIPAPANCHALL
      Qrew Member
      3 years ago
      Thank you! That did the trick.