How Do You Use the DATEADD Formula to Automatically Set a Due Date Based on the Issue Date?
In Jestor, the DATEADD function adds an interval of days, months, or another unit to a base date, letting you automatically calculate the due date from a contract's or bill's issue date.
Why automate this calculation
Manually setting the due date on every record is repetitive and error-prone, especially when the term is always the same, like 15 days after issuance. The formula removes that manual step.
How the DATEADD formula works
- You pick the date field that will serve as the base, like "issue date"
- You define the interval to be added, like 15
- You choose the interval's unit: D for days, M for months, among others
- Jestor automatically calculates the new date whenever the base date changes
How to build the DATEADD formula in Jestor
- Add a formula-type column with a date return
- Search for the DATE ADD function inside the formula editor
- Select the source date field, the interval, and the unit (D, M, etc.)
- Click create — the due date field is now calculated on its own
Process automation with always-correct deadlines
Automating the due-date calculation with process automation keeps the team from forgetting to fill that field in manually, keeping Jestor's financial deadlines always consistent with company policy.
Table Summary
| DATEADD parameter | Example from the video |
|---|---|
| Base date | Issue date |
| Interval | 15 |
| Unit | D (days) |
Video Tutorial: Step by Step
Video: Ep 18: Formulas in Jestor — video tutorial showing this feature in practice, right inside the Jestor interface.
Frequently Asked Questions
Does the DATEADD formula only work with days? No, it also accepts months and other time units, depending on how it's configured.
Does the due date change if I later update the issue date? Yes, since it's a formula, the result recalculates automatically.
Do I need to know how to code to use DATEADD? No, the function is selected right inside the jestor.com formula editor, no code needed.
Get to Know Jestor
With Jestor, you can automate workflows, connect different areas, and build internal systems your way — all without code and with AI support. Check out Jestor at jestor.com and discover how to take your company's management to a new level of efficiency and integration.