Need to display pxCreateDateTime in Report viewer in Format(dd/mm/yyyy)
I want to convert a datetime to date within the function alias with the Server timestamp. I know @formatedatetime function is there. but can I use this function in function alias for reporting purpose or is there anything I can play within function alias.
Thanks in advance.
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
Pegasystems Inc.
IN
Hello,
Thank you for posting your query in PSC.
You can try the below steps to achieve your requirement.
- Open the column options in the report definition.
- Configure the Column Format to 'Date Time'
- Click on Magnifying icon and configure Type as "Date" and select the appropriate Date format from the DropDown.
Hope this helps !
Thanks,
Geeda.
Pegasystems Inc.
IN
Hi Jonny,
Have you tried the gear icon to configure column options as suggested in the below article:
https://collaborate.pega.com/question/need-set-date-format-ddmmyyyy-while-displaying-report
Thanks!
Accepted Solution
Pegasystems Inc.
IN
Hello,
Thank you for posting your query in PSC.
You can try the below steps to achieve your requirement.
- Open the column options in the report definition.
- Configure the Column Format to 'Date Time'
- Click on Magnifying icon and configure Type as "Date" and select the appropriate Date format from the DropDown.
Hope this helps !
Thanks,
Geeda.