DMGoldie Posted June 11, 2008 Share Posted June 11, 2008 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 Link to comment Share on other sites More sharing options...
comment Posted June 11, 2008 Share Posted June 11, 2008 What is a work week? Link to comment Share on other sites More sharing options...
flook Posted June 11, 2008 Share Posted June 11, 2008 (edited) 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 Link to comment Share on other sites More sharing options...
mr_vodka Posted June 11, 2008 Share Posted June 11, 2008 pending that the work week starts on sunday and ends on saturday... Link to comment Share on other sites More sharing options...
DMGoldie Posted June 11, 2008 Author Share Posted June 11, 2008 Brilliant - thanks! For this job the work week = Monday through Friday. Thanks again for your help! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5798 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now