tigergirl Posted September 22, 2006 Share Posted September 22, 2006 Hi everyone, I've been working in web development for a while and away from FileMaker, and now that I need to use it I find that I'm VERY rusty! I appreciate any help that you can provide. I want to set up a field that automatically calculates a priority list based on an entered due date. For instance, if the due date is today or tomorrow, the priority would be Very High. If the due date is the day after tomorrow, the priority would be High. The day after that would be medium, and anything after that would be low. I also want it to only count weekdays, if that's possible. Can anyone help? Thank you SO much! Very best, TigerGirl Link to comment Share on other sites More sharing options...
BobWeaver Posted September 23, 2006 Share Posted September 23, 2006 (edited) In FMP 6 and earlier the calculation (unstored) would be: Case(DueDate Choose(Min(Max( Int((DueDate - Status(CurrentDate))/7) * 5 + If(DayofWeek(DueDate) < DayofWeek(Status(CurrentDate)),Min(5, DayofWeek(DueDate) - 1) + Max(0, 6-DayofWeek(Status(CurrentDate))),If(DayofWeek(Status(CurrentDate)) < 7, Min(6,DayofWeek(DueDate)) - DayofWeek(Status(CurrentDate)), 0)) -1,0),3), "Very High","High","Medium","Low") ) For FMP7 and later, change the commas to semicolons, and change Status(CurrentDate) to Get(CurrentDate) Edited September 23, 2006 by Guest Link to comment Share on other sites More sharing options...
tigergirl Posted September 24, 2006 Author Share Posted September 24, 2006 Thanks so much, Bob!! I'll try it when I get to work on Monday. Blessings~ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6559 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