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.

Date Calculation

adyf
in Calculation Engine (Define Fields)

Featured Replies

I have created a date calculation field and want it to automatically calculate two years minus a day from another field:

i.e. Date: 25/12/2008 Calculation: 24/12/2010

If I add 730 days to the first field I sometimes get the right calculation but not always. I suspect leap years come into the equation but I'm not sure how to deal with this. Any help would be greatly appreciated.

Technically, two years minus a day would be =

Date ( Month ( YourDate ) ; Day ( YourDate ) - 1 ; Year ( YourDate ) + 2 )

I say "technically", because there can be more that one correct answer to what is "two years minus a day" away from February 28/29 - it's largely a matter of preference. The above formula will return Feb. 28 if YourDate happens to be Feb 29, and Feb 27 when YourDate is Feb 28 (even if the the year of the result is a leap year).

  • Author

Thanks for the reply, that's exactly what I was after. Easy when you know how I guess.

Create an account or sign in to comment

https://fmforums.com/topic/64774-date-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.