Report fails when using a date field with “plus” or “minus” value filters #5353

New issue

Open

opened 2026-02-20 17:00:03 -05:00 by deekerman · 2 comments

deekerman commented

2026-02-20 17:00:03 -05:00

Owner

Originally created by @urdhvatech on GitHub (Nov 7, 2025).

Issue

When creating or running a report that includes a date-type field, the report fails to execute properly if the filter condition uses relative date values such as “plus” or “minus”

Possible Fix

Pull Request Created
https://github.com/SuiteCRM/SuiteCRM-Core/pull/796

Steps to Reproduce the Issue

1.Go to Reports module.
2.Create a new report on any module that has a Date field.
3.In the conditions choose the date field and operator as Equal, Type = Date and set a condition value Today using plus or minus (for example, “Date is greater than Today +7 days”).
4. when you click on Update button to retrieve result. 
5. It will show you blank page.
...


### Context

_No response_

### Version

8.9.0

### What browser are you currently using?

Chrome

### Browser Version

Version 142.0.7444.60

### Environment Information

MySql, PHP8.2

### Operating System and Version

Linux

Originally created by @urdhvatech on GitHub (Nov 7, 2025). ### Issue When creating or running a report that includes a date-type field, the report fails to execute properly if the filter condition uses relative date values such as “plus” or “minus” <img width="1518" height="574" alt="Image" src="https://github.com/user-attachments/assets/da53fb6d-9492-43d8-9a48-2cabe4b69916" /> ### Possible Fix Pull Request Created https://github.com/SuiteCRM/SuiteCRM-Core/pull/796 ### Steps to Reproduce the Issue ```bash 1.Go to Reports module. 2.Create a new report on any module that has a Date field. 3.In the conditions choose the date field and operator as Equal, Type = Date and set a condition value Today using plus or minus (for example, “Date is greater than Today +7 days”). 4. when you click on Update button to retrieve result. 5. It will show you blank page. ... ### Context _No response_ ### Version 8.9.0 ### What browser are you currently using? Chrome ### Browser Version Version 142.0.7444.60 ### Environment Information MySql, PHP8.2 ### Operating System and Version Linux

deekerman added the

labels

2026-02-20 17:00:03 -05:00

deekerman commented

2026-02-20 17:00:05 -05:00

Author

Owner

@johnM2401 commented on GitHub (Nov 7, 2025):

Hey!
Thank you for raising this issue.

Just for your information, I've transferred this over to the SuiteCRM 7 repository as the issue can also be replicated in the latest SuiteCRM7 release and is not specific to SuiteCRM 8.

Thank you for your time and contributions to the project!

@johnM2401 commented on GitHub (Nov 7, 2025): Hey! Thank you for raising this issue. Just for your information, I've transferred this over to the SuiteCRM 7 repository as the issue can also be replicated in the latest SuiteCRM7 release and is not specific to SuiteCRM 8. Thank you for your time and contributions to the project!

deekerman commented

2026-02-20 17:00:05 -05:00

Author

Owner

@urdhvatech commented on GitHub (Nov 7, 2025):

Hey! Thank you for raising this issue.

Just for your information, I've transferred this over to the SuiteCRM 7 repository as the issue can also be replicated in the latest SuiteCRM7 release and is not specific to SuiteCRM 8.

Thank you for your time and contributions to the project!

Yes that is correct, This issue can be replicated in SuiteCRM 7 version as well.

@urdhvatech commented on GitHub (Nov 7, 2025): > Hey! Thank you for raising this issue. > > Just for your information, I've transferred this over to the SuiteCRM 7 repository as the issue can also be replicated in the latest SuiteCRM7 release and is not specific to SuiteCRM 8. > > Thank you for your time and contributions to the project! Yes that is correct, This issue can be replicated in SuiteCRM 7 version as well.