Split a date range into their days
0
Hi all, Is it possible to split a date range into their days? Example Input: StartDate is 13/07/2020 EndDate is 17/07/2020. Result: 5 Objects with single Days. Maybe it works with a microflow and a loop function... Or, is there possibly another way? I need the possibility to enter specific working hours in the date range for each day
asked
Andreas Bayer
3 answers
4
You could use adysBetween to calculate the number of days.
And a loop using a merge to create an object for each day.
Something like this?
answered
Michiel Arts
1
Made it :) Thanks to all :)
answered
Andreas Bayer
0
You could indeed use a loop construction in a microflow, using addDays($variable,1).
If you want to take into account holidays, besides weekend days, I would propose a Day entity. Make pages so you can manage the days. Then use it by querying the database like [date >= 13/07/2020 and date <= 17/07/2020 and working_day = true]. When using the aggregate microflow action to counting the number of days, this should be a well performing query.
answered
Johan Flikweert