Substring in InfoPath

To get a value AFTER a charactersubstring-after(FieldName, “;”)This will return all text after the character ; To get a value BEFORE a character substring-after(FieldName, “;”)This will return all text before the character ; Substring and Concatenate I often use Concatenate to join text from two fields. For example, the Date function now() has a “T” between Date …

Working with Date formats in InfoPath

To extract the day number of a date number(substring(DateField, 9, 2)) To extract the month number of a datenumber(substring(DateField, 6, 2)) To extract the year number of a datenumber(substring(DateField, 1, 4)) Calculate hours addSeconds(now(), 7200) Get the month name from a date (and time) field =TEXT([DateField];”mmmm”) Get three characters of the month name=TEXT([DateField];”mmm”) Sort or group …

Error in the personal information on MySite

If you see this error on the MySite and personal information page: “There was a problem retrieving data for this field. Updating values in this field is disabled temporarily. You can still update values in other fields.” Then something is wrong with the Managed Metadata Service. Clicked on the service app for Managed Metadata service …

Form has been closed

This post is more for my own memory, since I tend to forget how I solved it when I get this message “Form has been closed” when submitting browser forms in InfoPath 🙂 Scenario is the following:You have a mail view that you wish to mail instead of the default Edit form, so that you …

Installation of Windows 8

Today I installed Windows 8 on my laptop. It was very fast and easy, I did these steps: Booted on USB Since I ran a Home Edition of Windows 7, I was not able to select “Upgrade” since I am installing an Enterprise version. So it had to be “Custom: Install Windows only (advanced)” which …