• Dates
• Decimals

---

Dates

When working with dates in the API, the format depends on whether you are using generic or explicit functions. The following are guidelines, but you should always check the API documentation for the particular date field to confirm you are using the correct format.

• With generic functions, dates are typically strings in the format mm/dd/yyyy. For example:

  <create>
     <APBILL>
        <WHENCREATED>12/22/2018</WHENCREATED>
        ...
     </APBILL>
  </create>
  

• With explicit functions, dates are typically objects in the format:

  <create_invoice>
     <customerid>CUSTOMER1</customerid>
     <datecreated>
        <year>2018</year>
        <month>06</month>
        <day>30</day>
     </datecreated>
        ...
  </create_invoice>
  

• Some functions related to audit trails accept query parameters for timestamps in the format MM/DD/YYYY HH:MM:SS. For example:

   <readByQuery>
      <object>AUDITHISTORY</object>
      <fields>*</fields>
      <query>ACCESSTIME='03/31/2018 16:24:51'</query>
      <pagesize>100</pagesize>
   </readByQuery>
  

Dates in Sage Intacct do not have associated timezones. See the FAQ for more information.

Decimals

Decimal values should not include commas. Convert decimal values with commas to the correct format. For example, 1,000.00 must be converted to 1000.00.

Provide feedback