Derive 0fiscyerar from 0calmonth in a query
We need to build a query which will show three columns: the first two will use calendar month using the value of the entry variable the user will enter. The third one has to show YTD values using 0fiscyear. But the user only wants to enter 0calmonth, so, is there a way to derive 0fiscyear from 0calmonth in a query?
Thanks in advance