dysong3 Posted January 31, 2021 Posted January 31, 2021 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?
comment Posted January 31, 2021 Posted January 31, 2021 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.
Recommended Posts
This topic is 1403 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now