Find This Week

[DMGoldie]

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

[comment]

What is a work week?

[flook]

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, 2008 by Guest

[mr_vodka]

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

[DMGoldie]

Brilliant - thanks!

For this job the work week = Monday through Friday.

Thanks again for your help!