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

 Raja Aruchamy (RajaA117)
Verizon

Verizon
US
RajaA117 Member since 2020 3 posts
Verizon
Posted: Feb 10, 2020
Last activity: Feb 13, 2020
Posted: 10 Feb 2020 12:22 EST
Last activity: 13 Feb 2020 4:12 EST
Closed

how to get a list of dates between two dates in a report column

I want to create a report with a column which give the list of dates between two dates. Can someone help me out. Thanks in advance

***Moderator Edit-Vidyaranjan: Updated Platform Capability***  

To see attachments, please log in.
User Experience

Posted: 4 years ago
Posted: 11 Feb 2020 1:49 EST
Kaviya Shree Velusamy (veluk)
Pegasystems Inc.
System Architect
Pegasystems Inc.
IN

I think OOTB functions doesn't exist for this functionality. I doubt it could be achieved through a custom function as well.

To see attachments, please log in.
Posted: 4 years ago
Posted: 12 Feb 2020 3:39 EST
Basil (Vasilii) Pozdeev (vaspoz)
BPM Company
Senior System Architect
BPM Company
NL

For sure it could be achieved.

Do you want to have a comma separated list? Like: "01-02-2020, 02-02-2020, 03-02-2020, 04-02-2020"?

To see attachments, please log in.
Posted: 4 years ago
Posted: 12 Feb 2020 11:27 EST
Raja Aruchamy (RajaA117)
Verizon

Verizon
US

Hello Vaspoz, I want the column to have these dates 01-02-2020, 02-02-2020, 03-02-2020, 04-02-2020, each one in a row, one below the other.  This is more like populating serial number in the report column. 

 

To see attachments, please log in.
Posted: 4 years ago
Posted: 13 Feb 2020 4:12 EST
Basil (Vasilii) Pozdeev (vaspoz)
BPM Company
Senior System Architect
BPM Company
NL

each one in a separate row?? That's not usually how you would work with a select DB query =)

Could you give an example (do it in Excel and attach as a screenshot)

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