Browser Forms

Re: Auto-Calculate Fiscal Year based on (today)

Nancy Young — Tue, 08 May 2012 18:14:22 GMT

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

Thanks,

nsy

Re: Auto-Calculate Fiscal Year based on (today)

jose cruz — Fri, 28 May 2010 02:19:56 GMT

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)

Re: Auto-Calculate Fiscal Year based on (today)

jose cruz — Fri, 28 May 2010 02:01:26 GMT

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.

Auto-Calculate Fiscal Year based on (today)

buck_murdock — Thu, 27 May 2010 22:08:47 GMT

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!