InfoPath Dev

 This can be done. You'll need some helper fields (naturally) Fields, LargeNumber, SmallNumber,Mod,Result Mod has the following default value  LargeNumber mod SmallNumber I added 2 rule to the smaller number field 1. Condition: if mod = 0 set result field to yes. 2. Condition: if mod NOT equal  0 set result field ...

 One Step closer. I've now changed my formula as follows: substring(eval(eval(Date[Hours > 0] | Hours[. > 0] | FullPartTime[Hours > 0], 'concat(";", .)'), ".."), 2) Output is 2016-05-09T00:00:00;AM;7;2016-05-10T00:00:00;PM;7   This at least gives me all my columns and data. I'm ...

 All,   Currently attempting to output rows of data from a repeating table to one long line. My repeating table has the columns date/hours/other   My current formula is substring(eval(eval(Date[Hours > 0], 'concat(";", .)'), ".."), 2) This outputs the date of each row ...

 I think if you publish the form and then open up the form, the domain name comes in as well.You might get other characters as well depending on your SP version and if you're using the getuserprofile service.

The AddSeconds option, was just not working for me.  If you use the Add Days function instead of the AddSeconds, you can then use the now () option. Add a now () field with the following formula as a default value - substring-before(now(), "T"), Then you can use the following to work out business days - ...

All, I've a field with a single small value which can be up to 2 decimal places i.e. 5.50 I've another field (total ) with  a much lager value i.e. 147. Can InfoPath do the equivalent of an excel MOD function. i.e. =IF(MOD(A1,B1)=0,"yes","no") ?  A1 being my larger number, B1 being my ...

The only way I can do it is to have 2 date controls fake (date), real (date/time) on the fake date control have a rule to set the real date control to the following concat(addDays(., 0), "T17:00:00") Then you could remove the real date part of the control, to the human eye, it would look like 1 control.

Thanks, didn't need to solve it in the end. Went down another road. 

Hilary, Thank you so much, The original expression formula seems to work, I've had to change my form slightly. I added a rule to my Start Date field so that it set the end date to be the same value when the start date changed. Then I added a second rule to my End Date field which was to set field 2 to the value of your ...

 Thanks, the count works if I add 1 to the event column in the repeating table. Yet, as soon as I change the End Date picker, it seems to go into a loop. It doesn't like the 1 in the event column in the repeating table. W