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.

fiscal quarter display problem

Featured Replies

I'm in a bit of a quandary here.  You can use the custom display of a date for it to appear as a fiscal quarter, eg Q1 2021.  But then, unless i am missing something,  it doesn't appear that you can do a search in the date field for what is displayed "Q1 2021".  The date field only manages to find the precise date which is not displayed.  So how do I go about finding a given quarter without knowing the precise dates?  Is there a work around for this? 

24 minutes ago, dysong3 said:

how do I go about finding a given quarter

You can find dates in a given quarter by searching for a range. For example, to find records in the !st quarter of 2021, you can:

Enter Find Mode []
Set Field [ YourTable::Datefield ; Date ( 1 ; 1 ; 2021 ) & ".." & Date ( 3 ; 31 ; 2021 ) ]
Perform Find []

Or course, the quarter start and end dates can be calculated from the input you have - but you didn't tell us anything about that.

 

Create an account or sign in to comment

Important Information

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

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.