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?