Report Definition is not showing till seconds in dateTime when exported to excel
Hi
I have a report Definition which shows pxCreatedateTime property till dd/mmyyyy hh:mm : ss but when exported to excel the second component (:ss) is not shown.I am receiving this excel in mail through report schedule.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Shell
IN
Pegasystems Inc.
IN
Hello Amit,
Thanks for posting queries in PDN.
Please go through the below support article , this may help you.
https://community.pega.com/support/support-articles/seconds-field-date-time-not-shown-excel-export
Thanks & Regards,
Durga
Capgemini
SE
Hi Durga
This is for listview. Do we have anything for Report Definition. I am not sure where to put this custom control mentioned.
Accepted Solution
Shell
IN
Hi Amit,
I have created a small usecase similar to your usecase and achieved the requirement.
Can you please refer the attached word document for the step by step process to achieve your requirement.
Do let me know if this helps you or if you still face difficulties in implementing the solution.
- Chinmai Sravanthi.
Capgemini
SE
Thanks...this works perfect in most cases!!! but this is not working when I am putting aggregate function on the date like max date or min date...
Pegasystems Inc.
IN
If the property is Datetime and you are using pxDateTime control, it should work. If not working you should raise SR, we should not have to use custom control for this.
-Saikat
Hi Amit,
I have created a small usecase similar to your usecase and achieved the requirement.
Can you please refer the attached word document for the step by step process to achieve your requirement.
Do let me know if this helps you or if you still face difficulties in implementing the solution.
- Chinmai Sravanthi.