Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

HELP working days calculation

jonny
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hi Im new on here, I didnt know this forum existed. Its brilliant, If i knew it was here it wouyld have saved me so much time. Anyway, I wondered if any of you could help with this:

I have 3 dates

date1 = date new job recieved

date2 = date job started

date3 = date job finished

I want to be able to perform a calculation that, finds the later date out of date1 and date2 then with that date find the number of WORKING days between that and date3.

Im not bothered about bank holidays I just want the calculation to miss out Saturdays and Sundays.

Any help will be much appreciated, Im quite new to filemaker and at the moment I keep getting asked to do this and that and instead of taking a few minutes like something like this would, its taking me weeks to work out myslef. Thannks!!

Jonny, please don't double post. We read all of the forums. This was a better choice for you to posted it, but see my answer in the other forum

frown.gif

Create an account or sign in to comment

https://fmforums.com/topic/15943-help-working-days-calculation/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.