Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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.
0