Jump to content

Number of Days in a Fiscal quarter

Priyank Dwivedi
Go to solution Solved by Kirsten Smith (she/her),

Recommended Posts

Can you clarify further what you are looking for? Do you want to select a date and then return the total number of days for the Fiscal quarter that contains that date? Or days to the end of the Fiscal quarter? Working days, or total days? With or without holidays? Once we have a better understanding of your request we can make suggestions.

Link to comment
Share on other sites

  • 2 weeks later...
  • Solution

I think you will find that this will be better accomplished in a TERR data function than using Spotfire functionality. You can read more about data functions here:


Here's a link to a YouTube video about creating data functions:

Link for TERR documentation:


I'd recommend that you start with the R package 'bizdays', as it has a lot of the functionality you are asking for:


Pass the selected date into the data function, then you can use the package to identify the fiscal quarter and return the desired number of days.

Link to comment
Share on other sites

  • 2 weeks later...

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...