What is the most effective way for capturing the current week (mon-sun).

I have a date field called “Meeting_Date”. If a record gets modified and the “Meeting_Date” falls during the current week, I want to trigger a script. How would you script and/or calculate this? Thank you for any insight.

The fact that you want a 'week' to run from Monday to Sunday complicates this a bit but the above functions can be combined to produce the date for the first and last days of the current week--which I think is what you wanted here?

A simple to follow method using Choose (Yes, you can also set up a calculation that adds/subtracts from the current date)

Make sure you script for what will happen with replace field contents if find returns zero records or its not on the right layout or another user has record lock on a record in the found set your trying to operate on.

Their are other methods to change data in batches that are more transaction friendly than Replace Field Contents.

just sayin that you should know the gotchas of Replace Field Contents in a hosted/multi user situation before choosing it as a method.

CASE() will execute until it finds a match. Since you have the time great than or equal to 14:00, the it will be skipped until that hour (or greater) on that day. The second will not be used if the first one is. So it looks like you have the correct order for DOW=6!

By the way, 14:00 is 2:00 PM everywhere in the world that I know. If you need 3 pm or greater, change the '14' to '15'. That is unless I'm misunderstanding your PostHour field?