Jump to content

Recommended Posts

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? 

Link to post
Share on other sites
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.

 

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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