Calculate the difference between two date picker

[Stefan W.]

Hello,

i would like to create a Form where i can fill dates in two date pikers.
A third Text field should show me the result of the days between both pikers.

I found a article and build my form like this.

http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm

Now i get only 0 days. The form will not calculate the days. Could you help
me?

Thanks
Stefan Würtemberger

 

[Swathi (GGK Tech)]

Hi,
Here is a pretty good link. Go through this.
http://www.infopathdev.com/forums/p/2226/9236.aspx#9236

 

[Stefan W.]

Hi,

thanks for the info, but how i create an onchangeafter event at InfoPath.
Sorry i´m usually don´t develop code.

Thanks
Stefan

 

[Shiva (GGK Tech)]

Hello,

Do you have solution for InfoPath project? Then you have to double click on
the date field then it will automatically goes to code and it will create
onAfter change event for that field.

Otherwise you can select your field,
Tools -> Programming -> Changed Event.

Then it will creates the on After changed event.

 

[Stefan W.]

Hi,

thanks. it don´t work. Could you send me a test file with this function?
That would be great.

Thanks
Stefan

 

[Madhuri]

Hi
Here the steps to on how to add events in infopath

1. Select Visual Basic under Project types section
2. Expand Visual Basic
3. Select Office
4. Select InfoPath Form Template under Templates section
5. Enter the name and Location
6. Click Ok
7. Browse to the template using 'On My Computer' options present under
"Create project from existing form template"
8. Click Ok
9. Solution file get created with the existing template
10. Go to design mode and
11. Right click on the Control that you want to write code on
12. Select Programming
13. You will find different events

Another option is
1. Go to 'Insert' menu
2. Select the required event


Thanks,

 

[Anuma(GGK Tech)]

Hi Steve,

This link will explains you how to caluculate the differnce between two
dates without using code. And also "edwardvn" attached his xsn file with this
forum. Can you verify that.

http://www.infopathdev.com/forums/p/1900/28360.aspx#28360

I hope this will help you.

 

[jano]

Hi Stefan and all!

This:
http://www.bizsupportonline.net/infopath2007/calculate-date-difference-infopath-rules-formulas.htm

didn't work for me neither(

note:
when I entered the functions: number, substring and floor; and clicked on
'verify formula', the infopath displayed Error indicating that there
shouldn't be any spaces between numbers 'startDate, 9, 2' etc.
So, I repaired the formulas deleting all spaces between numbers, but it
still didn't work after that.

I'm starting to believe that there is no other way to do this than code,
which I'm trying to avoid. So any ideas would be greatly appreciated.

thx,
jano

 

[Anuma(GGK Tech)]

HI,

Also verify below link.
http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/