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.

Difference in Dates as number of days

weststreet
in Calculation Engine (Define Fields)

Featured Replies

I have three fields...

1) date_due_in

2) date_actually_received

3) days_difference

I want to calculate the difference between field 1 and 2, and return a number (number of days) into field 3.

It's amazing how much time I waste when I don't know what I'm doing!

MW

You're gonna kick yourself when you see this...

Make days_difference to be a calculation (number) with the following formula:

date_actually_received - date_due_in

(the date fields need to be defined as type DATE.

Yes, FileMaker supports basic maths on non-numeric data types, in this instance dates, but so intuitive.

  • Author

That was too easy! Sometimes I over think these things. It works like a charm.

Thanks!

MW

Create an account or sign in to comment

https://fmforums.com/topic/42311-difference-in-dates-as-number-of-days/
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.