Total Days Opened Minus Weekends?

[snackcakes101]

Hi - I need to show users how many days a job has been opened in our system, based simply on the "Date Opened" field. Can FM subtract the number of weekends, or do I have to have another file for it to refer to?

THANKS!

[Lee Smith]

Hi,

Use this calculation in your field, and have = Number result.

Int((Your Current Date - Date Opened) / 7) * 5 + Mod(Your Current Date - Date Opened, 7) - Case(DayofWeek(Your Current Date) < DayofWeek(Date Opened), 2, 0)

Note: change the "Your Current Date" field to the name of your field to be use as the current date. Also, you can make your field a calculation with a date result by using Status(CurrentDate).

HTH

Lee

[snackcakes101]

Thank you soooo much... the calculation worked perfectly! I NEVER would have figured that out on my own..