New Date Calculation issue

[scottmcnitt]

I am trying to count 180 days from now with the issue that the end date calculation cannot land on a weekend or a holiday.  i have a collection for my holidays collectHoliday im struggling with the syntax for not letting land on the weekend or holiday.  im trying right now just with it not landing a holiday but im missing a lot i know:

Text Label (Text)

------------------

With({OriginalDaysToAdd: 180},
With({HolidayCount:
CountIf(
ForAll(
Sequence(OriginalDaysToAdd,1,1),
If(
Text(DateAdd(DatePicker.SelectedDate +OriginalDaysToAdd = DateValue(collectHoliday.HolidayDate)ShortDate),
1,0
)}
)
)

[scottmcnitt]

So i essentially need to add a switch to each different date count correct?  Cause that did seem to work.

[TheRobRush]

yes, that switch is shortening your formula for the display label, by taking care of the is this a weeknd and if so lets alter the date to check from the get go. if we dont do that we end up with havign to nest a bunch if is it a weekend? which weekend date, is this weekend date a holiday etc in the display field and it gets very hard to keep track of

[scottmcnitt]

My last issue is Months:

Since i clearly dont know what im doing here, i tried to modify the code to reflect months and that does not work so well.  its adding months instead of days so i need to figure that code out

[TheRobRush]

I think for  months, using 3 months as an example, it should work something liek this

extra onchaneg code

Switch(
    Weekday(DateAdd('Day 1_1'.SelectedDate,3,Months)),
    7, UpdateContext({x:2}), 
    1, UpdateContext({x:1}), 
    UpdateContext({x:0}));

display text code

Text(
    If(
    Text(DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x,Days),"[$-en-US]mmdd")
    in
                                            [
                                                ///STATIC HOLIDAYS

                                                ///0101 NEW YEARS DAY
                                                ///0619 EMANCIPATION JUNETEENTH
                                                ///0704 INDEPENDENCE DAY
                                                ///1111 VETERANS DAY
                                                ///1225 CHRISTMAS DAY
                                                0102,0116,0213,0220,0331,0529,0619,0704,0904,0922,1110,1110,1124,1125,1225],
                                            Switch( 
                                                    Weekday(DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x,Days)),
                                                    7, DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x+2,Days),
                                                    6, DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x+3,Days),
                                                    DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x+1,Days)),
                                            Switch( 
                                                    Weekday(DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x,Days)),
                                                    7, DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x+2,Days),
                                                    1, DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x+1,Days),
                                                    DateAdd(DateAdd('Day 1_1'.SelectedDate,3,Months),x,Days))),ShortDate)

[scottmcnitt]

Looks like none of the holidays are working for this example i am using the 45 day section.  Here is the text label

Here is the DatePicker

For 45 Days is should be 2/21/2023 and not 2/20/2023 based on the holidays

[TheRobRush]

Haven't set it up on my side yet to test out but just first glance, I would guess it has something to do with your dateadd in first image, DateAdd should be DateAdd(start date, added time, unit of time). so need a , Days added on to it. see if that changes your result

[scottmcnitt]

i added Days it did not change.

[TheRobRush]

Went ahead and loaded it up on my side,

Problem is in the text property, initial check should be on a double DateAdd() one ofr the 45 days, and one for the date adjustment that you did in the calendar onchaneg to account for sat&sun.

Change to

Text(
    If(
    Text(DateAdd(DateAdd(DatePicker.SelectedDate,45,Days),e,Days),"[$-en-US]mmdd")
    in
                                            [
                                                ///STATIC HOLIDAYS

                                                ///0101 NEW YEARS DAY
                                                ///0619 EMANCIPATION JUNETEENTH
                                                ///0704 INDEPENDENCE DAY
                                                ///1111 VETERANS DAY
                                                ///1225 CHRISTMAS DAY
                                                0102,0116,0213,0220,0331,0529,0619,0704,0904,0922,1110,1110,1124,1125,1225],
                                            Switch( 
                                                    Weekday(DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e,Days)),
                                                    7, DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e+2,Days),
                                                    6, DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e+3,Days),
                                                    DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e+1,Days)),
                                            Switch( 
                                                    Weekday(DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e,Days)),
                                                    7, DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e+2,Days),
                                                    1, DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e+1,Days),
                                                    DateAdd(DateAdd(DatePicker.SelectedDate, 45, Days),e,Days))),ShortDate)

[scottmcnitt]

still sitting on 2/20/2023 when it should be on 2/21/2023

[scottmcnitt]

nm its working now.