Question
Accenture
IN
Last activity: 7 Oct 2024 6:46 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.
Accepted Solution
Updated: 27 Jun 2023 1:20 EDT
Accenture
IN
- I have created two properties: one is a date type (Date1) and another is a date-time type (Date2).
- I assigned User input to Date1.
- I am calling one DT to assign this value to Date2 and also appending a time function to Date1.
for eg.,Date2= Proprietary information hidden(00,00,00)
4. And passing this Date2 value in RD.
TCS
IN
@Lakshmi Priyanka Please try below function for date format PFA
Accenture
IN
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
Accepted Solution
Updated: 27 Jun 2023 1:20 EDT
Accenture
IN
- I have created two properties: one is a date type (Date1) and another is a date-time type (Date2).
- I assigned User input to Date1.
- I am calling one DT to assign this value to Date2 and also appending a time function to Date1.
for eg.,Date2= Proprietary information hidden(00,00,00)
4. And passing this Date2 value in RD.
Bits in Glass
US
@Lakshmi Priyanka no, the function suggested by @Pavan Bojja will give you the complete date without time value.