Is there a DateDiff command that you can use in an

[scott]

Is there a DateDiff command that you can use in an
expression box

 

[Steve Culhane [MS]]

Scott,
Which Office application do you want to do this with?
Is it that you want to get a DateDiff in Excel.


Stephen Culhane
(e-mail address removed)
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Content-Class: urn:content-classes:message
| From: "scott" <[email protected]>
| Sender: "scott" <[email protected]>
| Subject: Is there a DateDiff command that you can use in an
| Date: Thu, 17 Jul 2003 07:32:52 -0700
| Lines: 3
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNMcE4RH9pIgNPtSD2tsi80xNmQMA==
| Newsgroups: microsoft.public.office.developer.vba
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.office.developer.vba:16298
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.office.developer.vba
|
| Is there a DateDiff command that you can use in an
| expression box
|
|

 

[Van T. Dinh]

It is a function, NOT a command.

It is part of the DateTime Class of the VBA Library so it available in VBA
code.

Whether it works in an "expression box" (whatever it means) depends on which
application you are talking about. For example, I can use in a TextBox
Control in an Access Form without any problem. It is available in VBA for
other Office applications but whether it works in an "expression box", I
can't say..

 

[Steve Culhane [MS]]

Scott,
You should repost this message to the
microsoft.public.infopath discussion group.


Stephen Culhane
(e-mail address removed)
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
| Content-Class: urn:content-classes:message
| From: "Scott" <[email protected]>
| Sender: "Scott" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Is there a DateDiff command that you can use in an
| Date: Thu, 17 Jul 2003 13:28:36 -0700
| Lines: 56
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcNMof/BaI+kftp0RiuGTk2ainCIqg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.office.developer.vba
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.office.developer.vba:16301
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.office.developer.vba
|
| The app is Infopath. When desinging a vacation request I
| am trying to add an expression box with a total days off.
| I thought the code would be someting similar to this:
| DateDiff("d",[StartDate],[EndDate]) + 1
|
| After doing some research I found that the date:difference
| (d) is accepted but I cant figure out the rest of the
| command
|
| Am I close?
| >-----Original Message-----
| >Scott,
| > Which Office application do you want to do this with?
| >Is it that you want to get a DateDiff in Excel.
| >
| >
| >Stephen Culhane
| >[email protected]
| >Microsoft Developer Support
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "scott" <[email protected]>
| >| Sender: "scott" <[email protected]>
| >| Subject: Is there a DateDiff command that you can use
| in an
| >| Date: Thu, 17 Jul 2003 07:32:52 -0700
| >| Lines: 3
| >| Message-ID: <[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcNMcE4RH9pIgNPtSD2tsi80xNmQMA==
| >| Newsgroups: microsoft.public.office.developer.vba
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.office.developer.vba:16298
| >| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| >| X-Tomcat-NG: microsoft.public.office.developer.vba
| >|
| >| Is there a DateDiff command that you can use in an
| >| expression box
| >|
| >|
| >
| >.
| >
|