Skip 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.

Calculations with dates help

Featured Replies

  • Newbies

I am new to file maker pro, but so far think it will be very helpful and am already looking here for help because the FMP phone tech was not very helpful. I am hoping someone here can be...

I am running FMP 9.0 on XP, and have a database of highschool students. One of my desired fields is to have the birthdate of the student and their current age based on todays date. I set the field up to "calculation" and assumed I could put the following calculation:

age = // - Birthdate

When I did this I would get a number like 4783. In this first case, the student's b-day wassomething like 4/17/1995

Can anyone offer me assistance on how to properly write the calculation? please?

My second question is related to the first, but i would also like to have a calculation that automatically advanes the students grade level (ex. 9, 10, 11,...etc) at the end of June when graduation takes place. Again, any help ould be appreciated.

*Apologies if I posted in the wrong section.

See if these help:

http://fmforums.com/forum/showpost.php?post/150446/

http://fmforums.com/forum/showtopic.php?tid/181120/post/224869/#224869

  • Author
  • Newbies

Thanks for the quick response. I will try it first thing tomorrow at work and then let you know if I have success or not.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.