Hi @Anonymous ,
How do you list the days within a month in your app? Using Gallery?
Do you want to get all weekend dates within current month?
If you want to get all weekend dates within current month, I have made a test on my side, please consider take a try with the following workaround:
Set the OnSelect property of the "Calculate" button to following:
Clear(WeekDaysCollection);
ForAll(
FirstN([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30], DateDiff(Date(Year(Today()),Month(Today()),1), Date(Year(Today()),Month(Today())+1,1))),
If(
Weekday(Date(Year(Today()),Month(Today()),1) + Value)=1 || Weekday(Date(Year(Today()),Month(Today()),1) + Value)=7,
Collect(WeekDaysCollection, Date(Year(Today()),Month(Today()),1) + Value)
)
)
then add a Data Table control, set the Items property to following:
WeekDaysCollection
then all weekend dates within current month would be listed within the Data table.
If you want to display the days table as your screenshot mentioned in a canvas app, I afraid that there is no direct way to achieve your needs. As an alternative solution, you could consider add a Gallery control in your app to list all days in current month within the Gallery:
Set the Items property of the Gallery to following:
ForAll(
FirstN([0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30], DateDiff(Date(Year(Today()),Month(Today()),1), Date(Year(Today()),Month(Today())+1,1))),
Date(Year(Today()),Month(Today()),1) + Value
)
If you want to check if current date is weekend date, you could use the following formula:
If(
"Specific Date Value" in WeekDaysCollection,
"W.E"
)
Best regards,
