Reference · Finance
Date formulas
A date formula moves a date. Payment Terms use one (Due Date Calculation) to work out a document’s due date from its posting date, and an account schedule’s Comparison Date Formula uses one to move a column’s dates, such as to the same period last year.
Terms
A formula is one or more terms, each a number and a unit, joined by + or -:
| Unit | Means | Example |
|---|---|---|
D | Days | 30D: 30 days later |
W | Weeks | 2W: 14 days later |
M | Months | 1M: the same day next month |
Q | Quarters (3 months) | 1Q: three months later |
Y | Years | -1Y: the same day a year earlier |
C with a unit, instead of a number, is the end of the current one, and -C its start:
| Term | Means |
|---|---|
CW | The end of the week (weeks run Monday to Sunday) |
CM | The last day of the month |
-CM | The first day of the month |
CQ | The last day of the quarter |
CY | 31 December of the year |
Terms are applied from left to right. A month later than the 31st is the month’s last day. Spaces and lower case
don’t matter: 1m + cm is kept as 1M+CM. A blank formula leaves the date as it is.
Examples
From an invoice posted on 14/10/2026:
| Formula | Due date | Use |
|---|---|---|
0D | 14/10/2026 | Cash on delivery |
14D | 28/10/2026 | 14 days |
30D | 13/11/2026 | 30 days |
1M | 14/11/2026 | One month |
CM | 31/10/2026 | End of the month |
1M+CM | 30/11/2026 | End of next month |
CM+15D | 15/11/2026 | The 15th of next month |
In an account schedule column, -1Y compares a period with the same period a year earlier, and -1M with the month
before.
At Passion Bakery
| Payment Terms Code | Due Date Calculation |
|---|---|
| CASH | 0D |
| 14 DAYS | 14D |
| 30 DAYS | 30D |
Note
Date formulas are not the date shortcuts typed into date fields (t, t-1, 1401). Those are in
Dates.