1 2 Previous Next 17 Replies Latest reply on Feb 13, 2016 5:21 PM by user19752

    Using Substitute in a calculated field

    CarrieB.

      Hi there! I would like to use the "substitute" function in a calculated field, but I can't quite figure out how to get the calculation right.

       

      I have a calculated field that is "WeeklyMeetingReport-" & Get ( Current Date ) & ".pdf", which results in "WeeklyMeetingReport-2/12/16.pdf".

       

      However, I would like to substitute the "/" with "-" so that the result is "WeeklyMeetingReport-2-12-16.pdf".

       

      Can someone help me out? I'm sure it is super easy, but I am missing something.

       

      Thanks!!

       

      Carrie B.

        1 2 Previous Next