In Report Definition, I'm filtering the cases by using the pxCreateDateTime property.
I'm using the customised filter section to display the filters. In that section, I am displaying the From and To date fields. So when the user enters the date in that field (for e.g., From: June 15, 2023; To: June 20, 2023), the cases created in between those dates should appear. But pxCreateDateTime, From, and To are datetime properties.
On the UI, I am only capturing the date, not the time. So by default, the system is taking the current time.
The report should not consider the time. It should fetch the records based on the date range. Any help on this would be much appreciated.
***Edited by Moderator Marije to change type from General to Product, added Product details and Capability tags****