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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 653
André Arnaud de Cal... 463 Super User 2026 Season 1
Syed Haris Shah 308 Super User 2026 Season 1
