InfoPath Dev

 Please share so that others can learn too.

  =DATE(YEAR([Date Registered ANV]),MONTH([Date Registered ANV])+[Months],DAY([Date Registered ANV])) yes it is a common formula, but works in SharePoint calculated columns, not directly in an InfoPath form. If you have SharePoint you can use the above. You might be able to use something like - ...

 Look at OWA - do the users still 2 emails. Easy Thank You View -  http://blog.cube4.com.au/?p=491

 Just checked and the above formula does work in my test environment. as a calculated column :)

 Is this the only data connection you have on your form? What about to SP lists, button code etc./ The getuserprofile works fine in InfoPath forms which are in a InfoPath Web Part page on sharepoint.  Also for easy of use, can't use the service of the domain where the form is physically placed?

 The easiest way is to have extra text boxes and either hide them with rules or add them to a section and hide the section with a rule or show the new fields on subsequent views. The labels to the human eye are the same, but the field names are different. 1. You'll text boxes for the CurrentUser which is set on form load as you're ...

I've not got IP or SP to hand. Yet in excel you can work out what you want as follows using the following formula which you could try to see if it would work in a calculated column. B2 is your End Date and Time, A2 is your start Date and Time. =INT(B2-A2)&" days "&TEXT(B2-A2,"h"" hrs ...

I assume your forms are being used within SharePoint 2010. Does this happen for everybody or just some people? How are the drop down menu values being set? Are you setting them on the form within a drop down control? Are they being pulled down from a SharePoint list? If the updates are being made to the controls on the form directly, are the ...

 If the calculation is already done in the SharePoint list, you could create a form load rule or a query for data rule to set the 'total' field as required.

 so just before I play your date format is d/mm/yyyy or dd/mm/yyyy i.e. 30/01/2013 if January or 30/1o/2013 if October. substring(now(), 0, 5) works if your date is based on now(). Also just tested if your original date field is a date control it seems to work too. Check your original date control too. I've seen this ...