Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 vimalchand vijayakumar (Vimal Vijayakumar)
Cognizant
Associate
Cognizant
IN
Vimal Vijayakumar Member since 2023 10 posts
Cognizant
Posted: Aug 4, 2024
Last activity: Jan 9, 2025
Posted: 4 Aug 2024 7:46 EDT
Last activity: 9 Jan 2025 10:15 EST
Closed
Solved

Date issue in report definition

In the DB we are having the data for (Date) property is in different formats lets say :

1.DD/MM/YYYY

2.YYYY-MM-DD

3.YYYYMMDD

4.YYYYMMDDTHHMMSS

Now i want to sort all the data into ascending/descending order. Currently sorting is not happening properly how we can resolve this issue.

***Edited by Moderator Rupashree S. to add Capability tags***
To see attachments, please log in.
Pega Platform 8.8.5
Pega Platform
Data Integration
Data Management

Accepted Solution

Posted: 1 year ago
Updated: 1 year ago
Posted: 4 Aug 2024 23:20 EDT
Updated: 9 Jan 2025 10:15 EST
Soham Majumdar (SohamM95)
Maantic Inc
Senior Architect
Maantic Inc
IN

@Vimal Vijayakumar

You might have to create a custom function alias where you consider all the date formats you have and convert in into a single format and then sort on that format.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice