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.

differences between dates

Jorgitopeter
in Calculation Engine (Define Fields)

Featured Replies

Hi everyone! I have this little issue and couldn't find any answer in other topics. I hope you can help me. Thanks in advance!

I want to compare 2 dates: the current date, and the one written by the user. I want to know if the date written by the user is more than 60 days older than the day when the user is writing.

I mean, the user writes a date of a specific day (e.g. 07/15/2010). I'd want a calculation field that tells me if there are more than 60 days between the date written by the user, and the day when the user is writing (today 08/02/2010).

Please let me know if my bad English isn't good enough to be clear. Thanks again!

Hi Jorgitopeter,

What do you want to happen when the dates the meet your criteria?

  • Author

Hi Lee, thanks for answering.

What I'd need is that when the date written by the user is older than 60 days from the current date, the field returns 'NO'; if it isn't, the field should return 'YES'.

Can you figure that out? thanks a really lot!

Create the calculation field (result text) as

If(UserEnteredDateField ≥ Get(CurrentDate)- 60; "No"; "Yes")

  • Author

Thanks... tomorrow I'll test this field and then I'll tell you if I have lucky! Thanks a lot!!!

  • Author

Great!!!! Thanks a really lot for the help... I couldn't figure out how addition and substraction work with dates! Thanks again!

Create an account or sign in to comment

https://fmforums.com/topic/73128-differences-between-dates/
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.