1 Reply Latest reply: May 15, 2014 10:10 AM by Joe Berry RSS

    if filed date = x, and posted date = y, then make filed date be = y

    pth3x _

      My report has a column entitled "Charge Filed Date"

      and another column entitled "Charge Posted Date".


      One of the dates in "Charge Filed Date" is the null default "01/01/1970"

      but its "Charge Posted Date" is "04/07/2011"


      I want to write a calculated field that says:


      If the "Charge Filed Date" is "01/01/1970", then make that "Charge Filed Date" be the same date as the "Charge Posted Date", (i.e. "04/07/2011")


      I have not succeeded in writing such a function.

      Can anyone help?