Software (include version): Ancora, DocStar IDC, Epicor IDC

Use Case: Vendor invoice contains . as separators for dates. ex... 12.27.2021 or 12-27-2021 need to export as 12/27/2021

example below shows replacing both the period and dash w/ a "/"

Customer: Spirol

Prerequisites: N/A


  1. Formula listed below and make sure you set autocalculate and possibly calculate flags


Helpful Links: N/A