Forum Discussion

Qrew Member

4 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

Icon for Qrew Legend rank

Qrew Legend

4 years ago

Can you post a copy paste of your formula and the error?

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

DIPAPANCHALL
Qrew Member
4 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
  Qrew Legend
  4 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
    Qrew Member
    4 years ago
    Thank you! That did the trick.