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


Use Case: Client needs the date formatted mmddyyyy


Customer: N/A


Prerequisites: N/A


Instructions:

  1. Add the following formula to the date field 


    STRJOIN(FT_ACCOUNTNUMBER," ",STRRIGHT(FT_ISSUE_DATE,4),STRLEFT(FT_ISSUE_DATE,4))


Helpful Links: