Hi All, have been searching for hours, but cannot find an answer to my problem, I'm using a workaround at the moment, but it isn't very dynamic, or 'elegant'.
I've built a Staff Leave Request system, and all is good so far.. Now I'm adding in the 'nice to have' features.
When a Request is created, it adds all details to a SharePoint List, including a list of all dates between the start date and the end date. This all works fine, and is mainly used for preventing duplicate requests being created etc.
My problem is with searching between two date values.
For testing I have - StartDate Picker, EndDate Picker, and a ListBox which shows the ListOfDates table.
How can I search the 'Date Range' column in the Sharepoint List (which contains multiple lines of text - each line with a date value in text format) from the date values inside the ListOfDates collection?
The table of date values is collected any time either the StartDate picker or EndDate picker is changed. with the following OnChange formula -
ClearCollect(
ListOfDates,
ForAll(
Sequence(
Value(
DateDiff(
StartDate.SelectedDate,
EndDate.SelectedDate,
Days
) + 1
)
),
Text(
DateAdd(
StartDate.SelectedDate - 1,
Value,
Days
),
"[$-en-US]mm/dd/yyyy"
)
)
)
Anyone got any ideas?
