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 with Date calculation please!

Merit Solutions
in Calculation Engine (Define Fields)

Featured Replies

I have a table of Subscribers to a newsletter and a table of Subscriptions. I store the date they became a subscriber (JoinDate)but would like a quick and easy way to set their renewal date to be one year plus one month after their joining date. Obviously this has to take into account leap years etc..

Any helpful calculation would be much appreciated. Thank you

Make a calc'field containing this:

Date ( 1+Month ( joinDate ) ; Day ( joinDate ) ; 1+Year ( joinDate ) )

...the result should be of date-type as well!

--sd

If the renewal field needs to be manually modified, you can have your renewal date field be an auto-entry calcuated value of something like:

Date ( month ( registrationdate ) +13 ; day ( registrationdate ) ; year ( registrationdate ) )

* Edit: My post, posted late. Sorry Soren.

Edited by Guest
Post delayed

See also here.

  • Author

That's fine - thanks very much for the tip about the auto entry option - i forgot to mention amendment!

Create an account or sign in to comment

https://fmforums.com/topic/52315-help-with-date-calculation-please/
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.