How to get all dates between a date range

Question

I have two dates ex. 03/05/2021 & 03/10/2021, I am trying to get all dates within this range. (i.e 03/05/2021, 03/06/2021, 03/07/2021, 03/08/2021, 03/09/2021, 03/10/2021). 
 Please help me with it.

Carlos Santander · Accepted Answer

Define two rule inputs (ri!startDate, ri!endDate) for the following rule: 
 = a!foreach(
 items: enum(1+tointeger(ri!endDate-ri!startDate)),
 expression: ri!startDate+fv!item
)
 
 You'll want to add validations before using this in your application.

How to get all dates between a date range

Top Replies