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.

Find month and current year

Featured Replies

I have a field "maturity_date" with the format mm/dd/yyyy and would like for the user to click on a button that corresponds to the month they are wanting a reports content searched/based on. I have a layout that has a button for each month of the year. I just want the report to contain maturity_date for the month and current year.

Thanks

When ever doing range reports I do reccomend the Troi Ranges Plugin

But this can be done with out the plugin. You would need to create

a global text field where you would list the numerical equivalent of the maturity_date

seperated by the "

Ya don't need no steekin' plugins!

Make a calculation field: "Maturity_Date_Monthname" = MonthName(Maturity_Date).

Make a calculation field: "Maturity_Date_Year" = Year(Maturity_Date).

Make a calculation field: "Maturity_Date_Search" = MonthName(Maturity_Date) & Year(Maturity_Date).

To use it, create a user interface with one global field for monthname -- gMonthName -- and another for year -- gYear. Put a pop-up list on the monthname and year global fields based on the values in the Maturity_Date_Monthname and Maturity_Date_Year fields respectively.

Create a script that first checks the global fields have a value selected, then

Enter Find mode []

Set field ["Maturity_Date_Search", gMonthName & gYear]

Perform Find[]

  • Author

Thank you both!

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.