SQL Database Integration

Re: Date Calculation

Whitley — Sat, 08 Jul 2006 15:15:47 GMT

hi,

i have sucessfully to did it.
thanks you very much.
:)

Re: Date Calculation

K.Ramana Reddy — Fri, 07 Jul 2006 10:11:45 GMT

Hi,

this is vb.net code,

Dim date1 As Date
Dim date2 As Date
Dim date3 As Date
Dim date4 As Date
Dim date5 As Date
Dim d As Date
date1 = Convert.ToDateTime(thisXDocument.DOM.selectSingleNode("/my:myFields/my:field1").text)
date2 = Convert.ToDateTime(thisXDocument.DOM.selectSingleNode("/my:myFields/my:field2").text)
date3 = CDate(date1)
date4 = CDate(date2)
Dim daysElapsed As Int32

daysElapsed = DateDiff("d", date3, date4)
thisXDocument.DOM.selectSingleNode("/my:myFields/my:field4").text = daysElapsed

I hope this will help you,

Thanks.

Re: Date Calculation

Whitley — Fri, 07 Jul 2006 08:51:30 GMT

hi,

ok, but right now i am looking for some example code (vb.net) to calculate the date from user input.
so hope someone kindly advise.
thanks.

Re: Date Calculation

Kalyan Gaddam — Fri, 07 Jul 2006 06:25:47 GMT

Hello,

No both of them cannot work together. You can have any onething working. You cannot have managed code and Script working together.

Re: Date Calculation

Whitley — Fri, 07 Jul 2006 06:09:13 GMT

hi,

May i know whether can put vbscript and vb.net together into visual studio.net?
because i have load the form into infopath form into visual studio.net already.
thanks in advance.

Re: Date Calculation

Kalyan Gaddam — Thu, 06 Jul 2006 18:03:38 GMT

Hello,

Please read the links below
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1711
http://enterprise-solutions.swits.net/infopath/adding-time-calculating-differences.htm

I hope it will help you.

Date Calculation

Whitley — Thu, 06 Jul 2006 16:44:42 GMT

hi,

May i know how to write the coding to calculate two differ date?
Can anyone send the sample code/form to me.
thanks.