AnsweredAssumed Answered

Scripts to get dates that falls between fiscal year

Question asked by gnowc on Dec 5, 2012
Latest reply on Dec 6, 2012 by 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]

Outcomes