Hi All,

Any ideas how you would create a Find script that will find all Records with a Due Date for the current work week?

Thanks,

dmg

What is a work week?

Enter Find Mode []

Set Field (date_field ; (Get ( CurrentDate ) ) - DayOfWeek ( Get ( CurrentDate ) ) + 1 & "..." & (Get ( CurrentDate ) ) - DayOfWeek ( Get ( CurrentDate ) ) + 7

Perform Find []

sorry comment, your absolutely right, is a work week from monday to friday.

this search would be sunday to saturday of the current week...

Edited June 11, 200817 yr by Guest

pending that the work week starts on sunday and ends on saturday...

Brilliant - thanks!

For this job the work week = Monday through Friday.

Thanks again for your help!