How to round date to specific weekday?

Ask for Help
1

Would anyone have a suggestion for setting up a math field that calculates the next Sunday after another given date field?

We’re trying to ensure that our users receive an in-app prompt to update their availability every Sunday (which we’re doing with tabs/visibility settings). Here’s how we picture it working:

  • User 1 updates their availability on Monday 19 September 2022, automatically setting ‘Availability updated’ date field to that day. ‘Availability prompt date’ math field is then automatically set for the following Sunday, 25 September, which triggers the scheduled reminder to check their availability.
  • User 2 updates their availability on Wednesday 21 September 2022, automatically setting ‘Availability updated’ date field to that day. ‘Availability prompt date’ math field is still automatically set for the following Sunday, 25 September so they receive the reminder on the same day.

Any guidance much appreciated!

2

Date - Weekday(Date) + 8

Screen Shot 2022-09-18 at 2.41.52 PM
Screen Shot 2022-09-18 at 2.41.52 PM882×284 54.3 KB

3 Likes
3

Darren, you are an angel from heaven. Thank you so much!!

1 Like
4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.