Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How should the data be formatted to correctly update the numeric or date fields in my documents?

0
Posted

How should the data be formatted to correctly update the numeric or date fields in my documents?

0

In general, the data that is placed in the transaction record by the trigger programs should be formatted exactly the same way that a user would manually enter the data into the Notes document field. For example, date fields should be formatted as “mm/dd/yy” or “mm/dd/yyyy” (in North America), and numbers should be formatted with decimal places, no commas, and leading minus signs (using RPG edit code “P”).

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123