Best answer

How do I specify 'Next Monday' as a date format range when creating events from user-submitted forms?

  • 5 September 2023
  • 2 replies
  • 65 views

Badge

Need help specifying a date format range. When a user submits a form on my site, I want to create an event for the following Monday.  

 

I’ve been trying to use the the date format action but could not figure out if there is a straightforward to way to specify “Next Monday” as a transform.

 

Thank you! 

icon

Best answer by RobertN2186 5 September 2023, 04:53

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Badge

I was able to figure this out. I’m reducing the date input to just day of week “dddd”. Then using a lookup table to add the appropriate number of days to the input. 

The process is detailed here: 

 

Thanks to @nicksimard; for providing this solution! 

Userlevel 7
Badge +6

That’s great news @RobertN2186! Glad to know you were able to get it sorted!

Also, thank you for sharing the solution here. This will be helpful to our other awesome Community members who might run into a similar issue.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊