Date formats for Velixo Financial functions
Created by Harry Lewis, Modified on Tue, 18 Jun at 6:11 PM by Harry Lewis
Applies to:
- Velixo NX
- Velixo Classic
- Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Advanced
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:
Our functions return the correct values because the dates shown are in a format which is recognized by Excel:
Incorrect Example
If our date format (in this case M/D/YYYY) was not recognized...
... our functions would result in an error:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article