Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator

Number of months for current fiscal year

Hi,

I need the number of months from today on for the current fiscal year, which starts on every 1.10.

E.g. for today I would expect to get 6, for monday (1.4.2019) I would expect 7. Any hints how to do that with a formula?

1 Reply
Vegar
MVP

Try this formula
Num(month(month name(DateField,3))) as [Fiscal month]