Question

Need to enter Date as DDMMYY on ACH Export scenario using the Provider.FormatDate funtion

  • 22 March 2024
  • 0 replies
  • 16 views

Userlevel 5
Badge

Good day Team,

 

I am trying to do do a date that will show DDMMYY instead of the funtion that is on the native export scenario for the ACH per our client ACH requirements. the Target Value is BH_CompanyDescriptiveDate, and the nativer field action on the export scenario is  =Provider.FormatDateMMMyy([Document.TranDate]), which provides the result “Mar 24” and I need “140324” to represent the Transaction Date for March 14, 2024,

 

Could not find a lot of documentation for the funtion FormatDate. 

 

Thank you Team.


0 replies

Be the first to reply!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved