Arbitrary date/time concept: "Every third Sunday of the month"

[alenamclucas]

I’m trying to retrieve something like “Every third Sunday of the month” from an Arbitrary date/time.

So for example, today is June 6, 2024 so I would want it to return June 16, 2024 as the next day in this pattern. Currently, I would guess it’s just matching to the word “Sunday” since I’m getting June 9, 2024.

Has anyone been able to accomplish this using Arbitrary date/time? Or is there a better method to accomplish this?

[Jici]

I don’t think you can use arbitrary date for this case because once you enter the text, Bubble try to read it and convert it to a date. This will remain.
However, if the goal is to target the next third sunday of a month (because I guess that if you are above the third sunday… it will wait for next month) you could use a mix of current date:set date to 1:rounded down to (week):+ days 21 … this should give you the third sunday of current month.
But, you also need to handle the case that current month third sunday is before current date. So you may need a conditionnal that will look like:
current date:extract date >= current date:set date to 1:rounded down to (week):+ days 21:extract date
If yes, calc will be current date:extract date >= current date:set date to 1+month 1:rounded down to (week):+ days 21:extract date