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***
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.
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"?
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.
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)