Question
Accenture
IN
Last activity: 27 Jun 2023 1:20 EDT
how to fetch date from DateTime field in Report Defination
Hi Team,
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.