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.

You should go without substitute in this case, because date separators vary from here to there.

Use

"WeekklyMeetingReport-" &

Month(Get(CurrentDate) & "-" &

Day(Get(CurrentDate) & "-" &

Year(Get(CurrentDate) & ".pdf*.