how to fetch date from DateTime field in Report Defination

User Experience
, ,
1

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.

2

@LakshmiPriyankaA

Please try below function for date format

PFA

Day_0.PNG
Day_0.PNG831×382 19.7 KB

3

Hi @Pavan Bojja,

That only picks the day value (for example, if the user provided 24/06/2034 1:30 AM, then that function would pick 24 as the day value).

My requitement is to fetch entire Date (like 24/06/2034). Thank you for the quick response

4
  1. I have created two properties: one is a date type (Date1) and another is a date-time type (Date2).
  2. I assigned User input to Date1.
  3. I am calling one DT to assign this value to Date2 and also appending a time function to Date1.

for eg.,[email protected](00,00,00)

  1. And passing this Date2 value in RD.
5

@Lakshmi Priyanka no, the function suggested by @Pavan Bojja will give you the complete date without time value.