I want date difference formula

[Anirudh Singh Chauhan]

I am facing date difference logic problem there is no formula in Infopath
about datediff

 

[virgul]

hi,

unfortunalty not you have to do that with code (If you want I have a
little example)!

++

 

[S Kahn]

Can you show me your example -thanks.

 

[virgul]

Sorry for the delay of my answer!!!

In which language? I have for JScript or C#!

++

Thierry

 

[Sandeep]

Hi Anirudh Singh Chauhan

This code is infopath Vbscript managed code.

Expl:
Field1 and field2 two are date pickers.
Field3 is textbox
Past this code

Sub CTRL18_5_OnClick(eventObj)

Dim nodeDate1
Dim nodeDate2
Dim dt1Val
Dim dt2Val
Dim daysElapsed

Set nodeDate1 = XDocument.DOM.selectSingleNode("/my:myFields/my:field1")
Set nodeDate2 = XDocument.DOM.selectSingleNode("/my:myFields/my:field2")

dt1Val = CDate(nodeDate1.Text)
dt2Val = CDate(nodeDate2.Text)

daysElapsed = DateDiff("d", dt1Val, dt2Val)

XDocument.DOM.selectSingleNode("/my:myFields/my:field3").text = daysElapsed
End Sub

I hope this will help U