Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / December 2007

Tip: Looking for answers? Try searching our database.

Add a day to today()

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LAEvans - 31 Dec 2007 17:47 GMT
How can I add a day to the today() function. I do not have the addDays
function and am having difficulty understanding where and how to put this in
the form. Keep in mind that I am very (2 days) with InfoPath.

Thank you in advance for your time!
Clay Fox - 31 Dec 2007 19:39 GMT
Two ways to do this with IP 2003, neither real nice. The best method is just
to use a bit of code.
You can use the datediff function in VBScript.  There are several examples
at http://www.infopathdev.com Just search on Datediff.

The other, low tech method is break the date down into its components,
increment the day and then put it back together, but this can lead to bad
dates say when it is the 31st unless you build some other logic/rules to know
when to change the month. This can be done with substring functions.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> How can I add a day to the today() function. I do not have the addDays
> function and am having difficulty understanding where and how to put this in
> the form. Keep in mind that I am very (2 days) with InfoPath.
>
> Thank you in advance for your time!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.