Get All Dates between start date and end date

0
Hello, i want to retrieve all dates between StartDate (1-12-2021) and EndDate ( 14-12-2021) by using microflow i want the result to be like (2-12-2021) (3-12-2021) ..etc. i hope someone can help. Thanks in advance
asked
1 answers
3

What do you mean with Retrieve?

Do you have these dates stored in the database, or do you want to determine all the dates between to given dates?

In the last scenario, what is your goal?

// Edit

You don’t want to retrieve the dates, but you want to compare.

You can do this by executing a retrieve which retrieves all rental contracts within the requested dates.

Source: From database
Xpath: [StartDate <  $NewRequest/EndDate and EndDate > $NewRequest/StartDate]

Variable: $ExistingRentalPeriod

After retrieve, check if resulting variable contains a result. $ExistingRentalPeriod  = empty

If true, then no other retal period exists, if false, it does

 

 

answered