Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i write to you because I have a problem i'd like to resolve.
I have some date, which belong to a fiscal integer, but the fiscal integer is not a date itself but an integer. (example: 1st april 09= 86, 1st april 10 = 87). this fiscal integer is invremented every april 1st.
However, not all the dates are used so not all of them are linked to the fiscal integer.
Is there a way to link them to the corresponding integer?
I wanted to try intervalmatch but it doesn't seem to work the way I want.
Does anyone have an idea about this?
I hope I express myself ok. Thank you in advance!
Looks like you have fiscal year starting on April 1st, and 0 is year 1923. Try if this is what you need:
=if(month(Date)>3, year(Date)-1923, year(Date)-1924)
Regards,
Michael
Thanks for your answer Michael.
Your answer will work but the fiscal integer is in the main table and not in the calendar, I will have data redundancy in this case (even if in QV it does not really matter i guess).
I tried linking the tables with a monthstart instead of linking with the whole date. It seems to work so far, i wonder if it will cause problems later
Regards,
cedric