Get list of dates that will fall on specific day of the week between two dates

[ParkLoey]

Hi there! I just wanted to share how I used Caspio's AI-powered GPT Connect to find all the dates that fall on a specific day of the week between two given dates.

I had always wanted to add this feature to my app, but I couldn't quite figure it out with calculations, and triggers definitely aren't my strong suit!

Here's my request for getting all the dates that will fall on Mondays between my start and end date values:

get the dates that will fall on a Monday between [@field:DateStart] and [@field:DateEnd]. Return only the list of result in the following format:
 
1: long date
2: long date

Here's the response:

The good thing about using this feature is that I can freely change the format on how I want the result to be like without going through extensive SQL 🥲

I created this value so I know when I need extra people for my company whenever an employee is on leave. I hope this helps other users with the same needs!