Jump to content

Calculating priority based on date


This topic is 6446 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by Guest
Link to comment
Share on other sites

This topic is 6446 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.