InfoPath Dev

Hi,

I need to show a progress counter against each user generated form.
I have a date field and want to subtract the date data entered for a particular job from todays date.

Anyone know a way to do this?

Cheers!

If you have 2007 there is a function for adding days, I believe you can add a negative number for subtraction. With 2003 you have to use script or code.  Search on DateDiff, which is the VBscript method, and you will find multiple examples here with sample script.

Using 2003. I'll check out the other.

Thanks!

Using Infopath 2003, this post will help you out and accomplish what you are needing.

http://www.infopathdev.com/forums/p/4730/25614.aspx#25614

Here is the one I was thinking of. http://www.infopathdev.com/forums/p/5646/21172.aspx#21172

The attached VBscript calculates 90 days in advance but should be easy to tweek. Lots of examples and documentation on DateDiff function itself.

Thanks Clay.

I also found this, which works in the example - http://enterprise-solutions.swits.net/infopath2003/article.php?t=datediff-vbscript-infopath&c=infopath2003