General

Re: Subtracting Dates

AndyB — Tue, 05 Feb 2008 07:44:10 GMT

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

Re: Subtracting Dates

Clay Fox — Mon, 04 Feb 2008 17:23:35 GMT

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.

Re: Subtracting Dates

barmatt80 — Mon, 04 Feb 2008 16:53:48 GMT

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

Re: Subtracting Dates

AndyB — Mon, 04 Feb 2008 14:55:39 GMT

Using 2003. I'll check out the other.

Thanks!

Re: Subtracting Dates

Clay Fox — Mon, 04 Feb 2008 14:46:59 GMT

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.

Subtracting Dates

AndyB — Mon, 04 Feb 2008 11:37:52 GMT

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!