January 31, 20214 yr 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?
January 31, 20214 yr 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