I need to figure out an expression that will take a given "datetime" field and use it to compute the datetime of the same day/week in the following month for a recurring scheduled event. For example:
If the field contains 2/8/2024 15:00, I need it compute 3/7/2024 15:00 because that is the second Thursday in the following month (basically the same functionality as Google calendar's repeat every week function). I've been wracking my brain and can't figure out a good way to do it in Appsheet's syntax (could do it all day in many other languages).
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |