REQUIREMENT:
require your help to see if it is possible to have a formula that allows me to filter a search saved by a range of periods.
Example this is my search:
Profit and Loss
The filter is of text formula type and the criteria is of text formula, in this example it brings me the periods of the year 2024 (selección)
Criteria:
Filter:
In this case I need to consult only the periods from January 2024 to June 2024, that is, the remaining months of the year 2024 do not appear, such as from July 2024 to October 2024, how could I do it with a formula?
SOLUTION:
By default, it is currently a system limitation under 170795 Lists > Search > Saved Searches > Available Filters tab > select Period > Notice that there is no way to select a specific period. The Available Filter Screen only permits relative period to be selected.
The alternate solution is to use Accounting Period Fields….Start Date