Acumatica Business Central Sage Intacct STACK Takeoff & Estimate Velixo Classic
Acumatica Business Central Sage Intacct STACK Takeoff & Estimate Velixo Classic

Date formats for Velixo Financial functions

Overview

When using dates (instead of financial periods) within your Velixo financial functions, ensure that the format used for your dates matches a date format that Excel recognizes.

Correct Example

Here we have a Velixo ACCOUNTTURNOVER function which references dates:

Excel showing an ACCOUNTTURNOVER formula referencing date cells in an Excel-recognized format, returning correct balance values


Our functions return the correct values because the dates shown are in a format which is recognized by Excel:


Close-up of date parameter cells showing a date format that Excel recognizes, confirming valid input for Velixo functions

Incorrect Example

If our date format (in this case M/D/YYYY) was not recognized...

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/R7T3UPKJXIeiJAjHV7SU_IFjQTwKKWlK8g.png


... our functions would result in an error:

Velixo function cell returning an error caused by an unrecognized date format passed as the date argument