Hi I created a datepicker with the help of some forum members here. I struggle now to make the date selection possible over different months. Is it possible to connect the repeater copies or what’s the best approach? I’m also not certain how to implement the selection from the end of one month to the beginning of the following.
Set startDay variable to the month times 1000 plus the day, so July 17th will be 7017, and do the same for the endDay variable. This lets you display the in-between dates regardless of month by testing if the same month/day column combo is between these variables. Note that this solution will not span years. (There’s a way to do that as well, but I’m assuming that since it’s a prototype that is not necessary.)
To display the start date and end date as dates, some math is needed to extract the month and day from this combined figure: e.g., 7017 will need to be displayed as 07.17.2019. I put that in the sample file. (Just swap the month and day if I put them in the wrong order.)
You also need to force all of the repeaters to redraw whenever a date is chosen
Here’s a sample. I put in comments explaining what is going on. Note that all repeaters have the same code.
oh wow joseph, thx for the explanation. I would have never thought to calculate the date as number. I will take your example and try to change from “swap” to replace the start date every time the end date is in the past of it.