In Table Created date and time filter not working .
Hi guys,
we have a record on the list with the time stamp of Aug 16, 2021 7:54:16 AM, but when I use the column filter for Updated Date and Time and select the entry 8/16/21 7:54 AM and click on Apply, I am not seeing the search result on the list.
Please help me how to resolve the issue.
Thanks in Advance!
Updated: 30 May 2024 6:22 EDT
Eclatprime Digital Private Limited
IN
Hey @kirti , may i get screenshot for your report definition rule ?? Still in case you can try this thing . I tried on my system to have a filter on Datetime property its working fine in case issue still exists , You can use Function "pxConvertDateTimeToText " and provide values in that format for Filteration. I don't have exact screenshot but below attached screenshot will help.
CI
IN
Hi
i used same thing but it's not working for me.
i am not able to attach the screen shot
After selecting that date it's shows null
Pegasystems Inc.
IN
CI
IN
Hi priyanka ,
previously i tried this one I am not seeing the search result on the list. Any another solution please suggest me
Pegasystems Inc.
IN
@kirti - If the table is sourced from the report definition rule. In report definition rule column level gear icon add pxDateTime format and click on gear icon to add the required format. I tested and even for filters its reflecting the format.
Thank you.
CI
IN
I tried this one also Priyanka, actually few dates when I search on filter data not available in table related that date. without filter that data available in table. I don't why I facing this issue