InfoPath Dev

I'm creating a IP 2007 form to help track a list of hardware orders from our many departments.  One of the fields we need is the Fiscal year in which the item was purchased.

 Can I have the Fiscal Year field in my form automatically calculate the fiscal year based on the date give in a field which has (Today) as the default value.  Our Fiscal Year runs from 10/01 - 09/30.  It seems like it wouldn't be too difficult, but i'm just not able to figure it out.

Thanks in advance for your help!

Hi Buck_Murdock,

You may try creating a rule that sets a field's value. The following settings might work for you:

Action: Set a field's value

Value: concat(substring(xdDate:Today(), 1, 4), "-", "01", "-", "01")

Hope it helps.

I forgot to mention that you should also set the condition on when the rule will be executed. An example is a rule that would only execute when QuarterBegin date is blank AND The expression "04" > substring(xdDate:Today(), 6, 2) AND "01" <= substring(xdDate:Today(), 6, 2)

I don't like to question gifts, but can you please break this down and explain why this piece of magic works? 

Thanks,

nsy