Newbie Questions

Re: Substring formula or Concat formula?

rgood — Thu, 21 May 2015 19:28:11 GMT

It works perfectly. How would I add 15 minute increments to the selection?

Re: Substring formula or Concat formula?

Reema Daga — Wed, 20 May 2015 23:34:57 GMT

Hi Ronald,

I have resolved the issue and emailed you the working copy. Please let me know if you still get the error!

Thanks,

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Re: Substring formula or Concat formula?

rgood — Wed, 20 May 2015 21:34:36 GMT

Everything up to and including the Day field is fine. However, once I put the formula into the Partial field it errors out. I am now limited to the Day field. The Partial field though is what I really need and I am dependent on the other fields to complete the calculation.

Re: Substring formula or Concat formula?

rgood — Wed, 20 May 2015 21:29:53 GMT

If I remove the calculations from the RealDays, Days, and Partial. I do not get the error when changing the date or time and it gives me HoursDifference.

Re: Substring formula or Concat formula?

rgood — Wed, 20 May 2015 20:33:16 GMT

send me an email and I will email the form

rgood@santafecountynm.gov

Re: Substring formula or Concat formula?

rgood — Wed, 20 May 2015 20:11:08 GMT

I am trying but I don't know how.

Re: Substring formula or Concat formula?

Reema Daga — Wed, 20 May 2015 20:01:41 GMT

Can you please attach your form here?

Thanks,

Reema

Re: Substring formula or Concat formula?

rgood — Wed, 20 May 2015 19:20:14 GMT

Nice try and good work but when I put in the first date and time and then the 2nd tape which defaults to 00 and I reset it. I get the following message: "The calculation in the form has not been completed. The number of calculations used for a single action exceeded the maximum limit"

How do the limit on number of calculations?

Re: Substring formula or Concat formula?

Reema Daga — Wed, 20 May 2015 17:34:02 GMT

Hi there,

For partial value, how about you use (RealDays - Day)? That will give you the difference.

Thanks,

Reema Daga
Qdabra® Software / InfoPathDev.com / FormsQuo / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Substring formula or Concat formula?

rgood — Wed, 20 May 2015 14:27:17 GMT

I have a calculation where I need to calculate the date and time so that the day gives me actual day rounded and then the decimal is given in the partial field.

I can’t get the partial field to work correctly to the 2 decimals with the decimal included.

Here are the functions I have:

Real Days: HourDifference / 24 = 5.46

Day: floor(RealDays) = 5

Partial: substring-after(RealDays, ".") this field needs to read ".46" or "46"