Current Fiscal Quarter

[Aditya Singh 3]

I am trying to get the current fiscal quarter for Jan 2020(i.e Q3)when my FY starts in July-June.

FiscalQuarter will give me Quarter for January month for all years as Q3, but I want to have a flag for current Quarter.

[Tyger Guzman 2]

FiscalQuarter(Today())

FiscalQuarter(Date(2020,1,1))

You can use the aboveexpressions to get current Quarter.

On your Document Properties ->FiscalYearOffset can be changed to have the start month of your fiscal calener match in Spotfire.

Specifies the number of months from the start of the calendar year to the start of the fiscal year.

For instance, a value of -1 specifies that the fiscal year starts in December of the previous calendar year, whereas a value of 2 specifies that it starts in March of the current calendar year.

[Aditya Singh 3]

Thanks for your response but as mentioned above this function will give me only querter number, but I want a way by which I can get a flag i.e, "Current Quarter" or "Not Current".

[Tyger Guzman 2]

That will get you exactly what you need!

 

 

 

Perhaps I should have explained more :

 

You can use more than one function in a if statement so you get a Boolean response if the years match the current year and current fiscalquarter or even use fiscalyear(). 

 

Using a year() and month() function combined you can achieve your results. 

 

 

 

Or even create a calculated column that concatenates the year and month and use that result versus the concatenation of today() or datetimenow() year and month. 

 

You can then use :

 

If(year([date])  =year(datetimenow) and fiscalquarter([date]) =fiscalquarter (datetimenow()) , true,false)

 

 

 

Check out this post as well https://spotfired.blogspot.com/2014/09/last-week-month-date-expressions.htmlm=1