Re: Time calculation: result field stays empty

Alec Pojidaev — Wed, 13 Apr 2011 20:28:49 GMT

Try forms in this blog:

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

Time calculation: result field stays empty

Emilio111 — Wed, 13 Apr 2011 13:18:22 GMT

Hello to everyone,

i'm trying to get a time calculation using no code with 3 (text-)fields.

The first is starttime using the conditions: itself not empty, endtime not empty, starttime is like 00:00:00

The following rule is implemented:

(((number(substring(../my:endtime, 1, 2)) * 3600) + (number(substring(../my:endtime, 4, 2)) * 60)) - ((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60))) div 60

The second is endtime, containing the similar conditions as starttime and has this rule:

(((number(substring(., 1, 2)) * 3600) + (number(substring(., 4, 2)) * 60)) - ((number(substring(../my:starttime, 1, 2)) * 3600) + (number(substring(../my:starttime, 4, 2)) * 60))) div 60

The thrid field (result) is the target for the rules settings.

The first test was fine, it worked properly. But it only worked for one time! Everytime i enter values in starttime or endtime the result field stays empty - it drives me mad!

So if anyone as any idea - please do not let my die stupid!

Best regards

Emilio111

General

Re: Time calculation: result field stays empty

Time calculation: result field stays empty