Question
4
Replies
114
Views
Posted: February 10, 2020
Last activity: February 13, 2020
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***
Posted: 11 months ago
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"?
Posted: 11 months ago
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.
Posted: 11 months ago
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)
I think OOTB functions doesn't exist for this functionality. I doubt it could be achieved through a custom function as well.