Using Dates with Sage Intacct functions

Overview

Using dates and date ranges is a fundamental aspect of reporting.

Here are a few particulars to keep in mind when using dates in your Velixo Sage Intacct reports.

Valid Date Formats

Hand-entered Dates

In order to maintain consistency throughout the various regions where Sage Intacct is used, Sage Intacct expects dates to be in the universal YYYY-MM-DD format.

Thus, if we were to enter a date in a Velixo function, we would use that format.
e.g.,

=SI.TURNOVER("Sage",,"10100","2024-01-01","2024-12-31","100"

Excel Dates

However, when placing our dates in separate cells, and then using cell references in our functions, the dates can be in a valid Excel date format.
e.g.,

Notice that our dates (in cells B1 and B2) are in a valid Excel date format: