Notifications
Announcements
No record found.
hi how can i substract days from a system date?
it should be added in a value to a range that belongs to a query
Hi AklG,
There is a DateTimeUtil class which has a method called addDays. This can also be used with a negative number. Then you are substracting days from a given date. You probably need to convert the date to utcdatetime and vice-versa.
If the second parameter is negative, the days would be subtracted.
DateTimeUtil::addDays(DateTimeUtil::getSystemDateTime(), -10)
The answers above might help if you're calculating the value in code and then using the calculated date in a query range. By the way, you can also use the minus operator with dates (e.g. systemDateGet() - 7).
But if you want to put an expression to a query definition that would calculate the date, you need something like (day(-7)).
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
