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.

Trouble with Month and MonthName functions

Featured Replies

I have a tool with the following fields.

studentDOB - a date field tracking birthdate

studentDOBMonthName - a calculation field returning text result - MonthName (studentDOB)

studentDOBMonthNumber - a calculation field returning number result - Month (studentDOB)

The DOB field works fine. But the other two fields return question marks.

This is an FMPA 17 file, hosted on FMS17, accessed on macOS 10.14.2.

Any help would be appreciated.

Possibly try - MonthName ( GetAsDate ( studentDOB ) )  and Month ( GetAsDate ( studentDOB ) )

If Month (studentDOB) returns an error, then my guess would be that studentDOB does not contain a valid date. What is a valid date is determined by the date format being used by the file: this could be either the format of the current system or the format of the system that first opened the file, as selected in File Options.

  • Author

Problem solved. As comment suspected, the problem was with the date field. The dates appear to be correct, but changing the format corrects the problem in the other fields. Thanks to both of you for your replies.

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.