Group:  Other Microsoft Office Products » microsoft.public.infopath
Thread: Calculate the difference between two date picker

Calculate the difference between two date picker
Stefan W. 12/10/2008 12:24:13 PM
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

RE: Calculate the difference between two date picker
Swathi (GGK Tech) 12/10/2008 12:33:09 PM
Hi,
Here is a pretty good link. Go through this.
http://www.infopathdev.com/forums/p/2226/9236.aspx#9236

--
Swathi Porandla
http://www.ggktech.com



"Stefan W." wrote:

[Quoted Text]
> 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
>
RE: Calculate the difference between two date picker
Stefan W. 12/10/2008 12:51:01 PM
Hi,

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

Thanks
Stefan

"Swathi (GGK Tech)" wrote:

[Quoted Text]
> Hi,
> Here is a pretty good link. Go through this.
> http://www.infopathdev.com/forums/p/2226/9236.aspx#9236
>
> --
> Swathi Porandla
> http://www.ggktech.com
>
>
>
> "Stefan W." wrote:
>
> > 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
> >
RE: Calculate the difference between two date picker
Shiva (GGK Tech) 12/10/2008 1:06:01 PM
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.

--
Shiva
http://www.ggktech.com


"Stefan W." wrote:

[Quoted Text]
> Hi,
>
> thanks for the info, but how i create an onchangeafter event at InfoPath.
> Sorry i´m usually don´t develop code.
>
> Thanks
> Stefan
>
> "Swathi (GGK Tech)" wrote:
>
> > Hi,
> > Here is a pretty good link. Go through this.
> > http://www.infopathdev.com/forums/p/2226/9236.aspx#9236
> >
> > --
> > Swathi Porandla
> > http://www.ggktech.com
> >
> >
> >
> > "Stefan W." wrote:
> >
> > > 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
> > >
RE: Calculate the difference between two date picker
Stefan W. 12/10/2008 1:20:01 PM
Hi,

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

Thanks
Stefan

"Shiva (GGK Tech)" wrote:

[Quoted Text]
> 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.
>
> --
> Shiva
> http://www.ggktech.com
>
>
> "Stefan W." wrote:
>
> > Hi,
> >
> > thanks for the info, but how i create an onchangeafter event at InfoPath.
> > Sorry i´m usually don´t develop code.
> >
> > Thanks
> > Stefan
> >
> > "Swathi (GGK Tech)" wrote:
> >
> > > Hi,
> > > Here is a pretty good link. Go through this.
> > > http://www.infopathdev.com/forums/p/2226/9236.aspx#9236
> > >
> > > --
> > > Swathi Porandla
> > > http://www.ggktech.com
> > >
> > >
> > >
> > > "Stefan W." wrote:
> > >
> > > > 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
> > > >
RE: Calculate the difference between two date picker
Madhuri 12/10/2008 1:28:02 PM
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,

"Stefan W." wrote:

[Quoted Text]
> Hi,
>
> thanks for the info, but how i create an onchangeafter event at InfoPath.
> Sorry i´m usually don´t develop code.
>
> Thanks
> Stefan
>
> "Swathi (GGK Tech)" wrote:
>
> > Hi,
> > Here is a pretty good link. Go through this.
> > http://www.infopathdev.com/forums/p/2226/9236.aspx#9236
> >
> > --
> > Swathi Porandla
> > http://www.ggktech.com
> >
> >
> >
> > "Stefan W." wrote:
> >
> > > 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
> > >
RE: Calculate the difference between two date picker
Anuma(GGK Tech) 12/11/2008 5:35:01 AM
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.

--
Anuma Reddy
http://www.GGKtech.com



"Stefan W." wrote:

[Quoted Text]
> Hi,
>
> thanks. it don´t work. Could you send me a test file with this function?
> That would be great.
>
> Thanks
> Stefan
>
> "Shiva (GGK Tech)" wrote:
>
> > 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.
> >
> > --
> > Shiva
> > http://www.ggktech.com
> >
> >
> > "Stefan W." wrote:
> >
> > > Hi,
> > >
> > > thanks for the info, but how i create an onchangeafter event at InfoPath.
> > > Sorry i´m usually don´t develop code.
> > >
> > > Thanks
> > > Stefan
> > >
> > > "Swathi (GGK Tech)" wrote:
> > >
> > > > Hi,
> > > > Here is a pretty good link. Go through this.
> > > > http://www.infopathdev.com/forums/p/2226/9236.aspx#9236
> > > >
> > > > --
> > > > Swathi Porandla
> > > > http://www.ggktech.com
> > > >
> > > >
> > > >
> > > > "Stefan W." wrote:
> > > >
> > > > > 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
> > > > >
RE: Calculate the difference between two date picker
jano 12/16/2008 6:49:02 PM
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

"Stefan W." wrote:

[Quoted Text]
> 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
>
RE: Calculate the difference between two date picker
Anuma(GGK Tech) 12/31/2008 12:54:02 PM
HI,

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



"Stefan W." wrote:

[Quoted Text]
> 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
>

Home | Search | Terms | Imprint
Newsgroups Reader