Hi Bubblers,
Im working on a monthly calendar that is created using bubbles current date/time and surprisingly Im almost there but am trying to figure out the best implementation to get the dates in the correct order of an actual calendar if anyone has any suggestions?
What I know so far:
The position of the first day of the month
0, 1, 2, 3, 4, 5, 6
Current date/time change date to 1 :rounded down to date (and can also extract the day to get 0, 1, 2, 3, 4, 5, 6)
How many days are in this month (and other months including leap years):
Current date/time +(months): 1 change date to 1 : rounded down to day +(days): -1 :extract date
We know we need 6 rows and we will have the 7 columns (0, 1, 2, 3, 4, 5, 6), so well need 42 positions.
I think the best way might be to somehow create a grid and have 7 checks:
If the 1st of this month has a day of 0 (may 1st on Sunday) we would know where all of the other days go and weather or not to show the dates 29, 30, 31
What has me stumped is how to reference R1, R2, etc…
I haven’t really tried option sets yet or maybe I could try storing the positions in the database and somehow reference groups in a grid? It would be great if you could enter positions dynamically (or at least I don’t know how).
Any ideas are greatly appreciated!