4 Replies Latest reply: May 15, 2014 10:08 AM by bminer _ RSS

    Replacing Dates

    bminer _

      Hi All,

      I have a field on a report (date field) that is valued with a dummy date if there is no actual data in the database.

      For example, if there isn't a date in the database, when the report is extracted, it comes out with the date 1/1/1960

       

      I want to create a calculated field that would show the actual field value, by doing a replace on the field for that date, but I can't seem to get it to work just right.

       

      Can someone help with this?

      Much appreicated,

      Ben