AnsweredAssumed Answered

Using Substitute in a calculated field

Question asked by CarrieB. on Feb 12, 2016
Latest reply on Feb 13, 2016 by user19752

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.

Outcomes