Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Extract Fiscal Year from a Date
We're trying to find the fiscal year from a date to display in a saved search. That is, the search results have a date column. We would like an additional column that displays the fiscal year that the date falls in, so that staff can quickly see in a list which fiscal year the date belongs to.
Is this possible with a formula (that doesn't need updating for each new year)? We can group by fiscal year, so it seems likely.
PS: You may have already inferred (correctly) that our fiscal year is not a calendar year.