Reference · Using Business Assistant
Dates
Dates are shown as dd/mm/yyyy. In a date field, a report option or a filter, you can type them in any of these forms. The examples take today to be Wednesday 14 October 2026.
Relative to today
| Type | Means | Example result |
|---|---|---|
t or today | Today | 14/10/2026 |
w | The work date, which is today | 14/10/2026 |
t+1, t-1 | Days from today | 15/10/2026, 13/10/2026 |
t+2w, t-1w | Weeks from today | 28/10/2026, 07/10/2026 |
t-1m, t+1m | Months from today | 14/09/2026, 14/11/2026 |
t-y, t+2y | Years from today (a missing number is 1) | 14/10/2025, 14/10/2028 |
+3, -1m | The same, counted from today without the t | 17/10/2026, 14/09/2026 |
fy | The first day of the current fiscal year, from Accounting Periods (1 January without them) | 01/01/2026 |
fy-1y | Counted from the fiscal year’s first day | 01/01/2025 |
A number without a unit counts days. A month added to the 31st lands on the month’s last day: 31/01 plus one month is 28/02 (or 29/02).
Day, month and year
| Type | Means | Example result |
|---|---|---|
14 | The 14th of this month | 14/10/2026 |
1401 | Day and month, this year | 14/01/2026 |
311 | Day (one digit) and month, this year | 03/11/2026 |
140126 | Day, month and two-digit year | 14/01/2026 |
14012026 | Day, month and year | 14/01/2026 |
14/1, 14.1, 14-1, 14 1 | Day and month with any separator, this year | 14/01/2026 |
14/1/26, 14.01.2026 | Day, month and year | 14/01/2026 |
2026-01-14 | The ISO form, year first | 14/01/2026 |
A two-digit year from 00 to 29 is 2000 to 2029; from 30 to 99 it is 1930 to 1999.
In filters
The same forms work in filters, alone or in ranges:
| Filter | Means |
|---|---|
t | Today |
t-7..t | The last seven days and today |
0110..3110 | October this year |
fy..t | The fiscal year so far |
..t-1 | Up to yesterday |
A date-and-time field filtered with a date alone takes the whole day; a time can follow the date, as 14/10/2026 14:30
or t 9:00. See Filters.
Date fields also open a calendar to pick from.