General

Re: Date() plus 3 days

Patrick Halstead — Wed, 24 Aug 2005 06:22:43 GMT

Ooh, very cool solution! Nice work WCO!

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Date() plus 3 days

wcotech — Tue, 23 Aug 2005 18:48:52 GMT

Hey Patrick,

Sine code and I don't work well together most of the time, I found another figuratively simple way to acheive my request. In my Access Project, I created a query that uses the formula "DATEADD(D,3,GETDATE())". I then created a secondary data connection to this field and now use it to compare to the start date. Works great, less filling!!!

Thanks Patrick!

Re: Date() plus 3 days

Patrick Halstead — Thu, 18 Aug 2005 00:02:02 GMT

Here's another link on how to do this in JScript:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvid/html/msdn_vidateadd.asp

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Date() plus 3 days

Patrick Halstead — Wed, 17 Aug 2005 23:59:13 GMT

Hi WCO!
Dates are different data types than whole numbers. You will need to add some code (OnAfterChange event handler function) to take apart the Date object and subtract 3 days from it and check it against Today. If it's true you can display a message box from code, or set some field that controls the message box. Dealing with dates is a frequent request. Check out the following MS blog on them:http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx
Good luck

Patrick Halstead [InfoPath MVP]
InfoPathDev

Date() plus 3 days

wcotech — Wed, 17 Aug 2005 19:56:57 GMT

Hey all,

I'm trying a condition and don't think it's working right. What I'm looking for is: "If [start date] is less than 3 days from today, display "72 hours" in a message box. The condition that I have tried is: [start date] is less than --->"today()+3" <---this a formula, which hasn't worked so far. If I take the "+3" off then the formula works great but I need to be able to check for a three day range. Any ideas?

Thanks!