2 Replies Latest reply on Dec 6, 2012 7:55 PM by gnowc

    Scripts to get dates that falls between fiscal year

    gnowc

      Hi everyone, I'm new to programming with Filemaker 12, and would appreciate any help you can give me.

       

      My company's fiscal year falls between Apr 1, YYYY to Mar 31, YYYY. I wish to define the value of variable with these parameters?

      Also the value for each of the 4 quarters within a fiscal year. Your guidance on this would be much appreciated. Thank you.

       

      For example:

      Set Variable [$curYear; Value: Year (Get (4;1;$curYear & "..." & 3;31;$curYear)]

      Set Variable [$prevYear; Value:Year($currentyear - 1]