Question

Retrieve a list of dates between a set of dates.

0

Hello all, I wanted to retrieve all the dates between two dates, like a list of dates in between toDate and fromDate. Is there any inbuilt function to do so, or some logic that will fulfill the same? Thanks :)

asked 2020-09-16

Ritika heda

1 answers

Rom van Arendonk · Answer 1 · 2020-09-16

In a microflow, if you have variables ToDate and FromDate, you can write an XPath constraint like:

[DateAttribute >= FromDate]
[DateAttribute <= ToDate]

In the user interface (e.g. on a DataGrid widget), you can use tokens like [%MonthLength%] – see the documentation here.