Distribute dates between two others days.

wow, that is a tricky ask. You would first need a table of holidays since Ninox has no way of knowing what holidays you follow. Then you would need to figure out how many days 25%, 70% and 90% is between the start date and end date. Then add those number of days to the start date, then check if it falls on a weekend then move the date out till it falls on a weekday then check if it falls on a holiday then move it out again till it falls on a weekday. Do you want the dates to always be on a particular day of the week (always on Mondays or always on Fridays)?

Spain probably has multi-day holidays, so in your holiday table you will have a date field and number of day field, this can default to 1.

I'll give it a shot but it could take awhile. I'm also trying to learn SwiftUI and that is hurting by brain. Now I know the difference between low code and 'real' code.

Hi Raphael, try this script. I also didn't quite understand why it starts at 10%. In line 3 you have to add an array for holidays, or a reference to a holiday table. Mirko

let all := days('Plan 1', 'Plan 5');
let start := 'Plan 1';
let holidays := [date(2024, 2, 6), date(2024, 2, 7)]; EXAMPLE
let allworkdays := workdays('Plan 1', 'Plan 5');
let result := for i in range(0, all) do
        let idx := date(year(start), month(start), day(start) + i);
        if weekday(idx) < 5 and not contains(holidays, idx) then
            text(date(year(start), month(start), day(start) + i))
        end
    end;
let twentyfive := round(cnt(result) * 15 / 100);
let seventy := round(cnt(result) * 60 / 100);
let ninety := round(cnt(result) * 80 / 100);
item(result, twentyfive) + " " + item(result, seventy) + " " + item(result, ninety)

Yes. holidays contains an array of dates, or selfemade select HolidaysTable.date.

If 'Plan 2' an so on are fx-fields then split the last line of script.
For 'Plan 2' 

item(result, twentyfive);

'Plan 3'

item(result, seventy);

and 'Plan 4'

item(result, ninety);

If you use button or trigger and fields are textfields then delete last line and take

'Plan 2' := item(result, twentyfive);
'Plan 3' := item(result, seventy);
'Plan 4' := item(result, ninety)

Mirko