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


Instructions:

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

    • STRREPLACE(STRREPLACE(FT_ISSUE_DATE,".","/"),"-","/")


Helpful Links: N/A