Expression to get the datetime of the same day of the week as a given datetime next month

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).

0 10 275
10 REPLIES 10
Top Labels in this Space