SpiceCRM
How to add the 365 days to date field
KReporter
rsp
May 29, 2026, 3:36pm
1
We could use the below customFunction for date field.
DATE_ADD({t}.{f}, INTERVAL 365 DAY)
Related topics
Topic
Replies
Views
Activity
Calculate number of days in the KReport
KReporter
1
14
May 27, 2026
Calculate number of days
KReporter
1
18
August 18, 2025
Truncating time off of Date Created field for Report
KReporter
2
556
February 11, 2026
Calculate days remaining from today's date
KReporter
1
941
February 20, 2018
How to find date difference between datetime and date field
2
22
November 3, 2025