Auto Date Update

S

Shameem Dubai

I am Using InfoPath 2003,
I have two fields in my access Database, Invoice date (Date field) &
Warranty Period (text) , I am saving warranty period in Days ( like 365, 730
etc)
What I need is to Update my ExpiryDate field by adding the above two feild,
for Ex: Invoice Date : 10/10/2007
Waranty period: 365
Then, it should update ExpiryDate field as 10/10/2008 automatically.
Please help me to solve this issue, I don't have much idea about codings
Thanks
 
P

Pramod K.

Hi Shameem,
Do you want to update the date in InfoPath or in Access
Database?
Coming to the InfoPath,
1. In the Rules of “Warranty Period†field set the condition that “Invoice
Date†as “is not blankâ€.
2. Then click on “Add Action†button.
3. In the “Action†drop down select “Set a Field’s Valueâ€.
4. In the “Field†text box select “Invoice date†field.
5. And in the “Value†text box add a formulae that “addDays(Invoice date,
Warranty Period)â€
Then the date will update automatically in "Invoice date" date picker when
you add integers in "Warranty Period" text box.

Pramodk.
 
Top