Selecting Full Weeks or Full Months

[Hyperbytes]

Tutorials here

Generating or adding to a list of dates in a table

Many applications need date lists such as calendars or lists to form the basis of custom date pickers In this simple tutorial i will show you how to generate a list of all dates within a specified date range While there are undoubtedly more efficient ways to do this using custom queries i have stayed with the inbuilt Wappler visual tools This routine will check for the presence of each date and will only add if missing, This allows the routine to be run on a regular basis or even as a schedul…

Filtering a date list using a Dataview to show only a selected day of the week in the list

This guide follows on from the previous guide: https://community.wappler.io/t/generating-or-adding-to-a-list-of-dates-in-a-table/16507 Before we can use the previously created table we need to make a basic query server action So we create a server action, in this case i called it 'getdate' we add database connection [image] and a Database query I have not added any conditions,. the query returns all records. To hide expired entries simple add a condition to ensure the date is => NOW follo…