Auto Date Update

[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

 

[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.

 

[Swathi (GGK Tech)]

Hi,
There is no builtin function in InfoPath 2003 to add days to a date like in
InfoPath 2007. To add days to a date, we need to write the code. Go through
the below link. It will explain how to add code to add days to a date using
code.
http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx