InfoPath Dev

 Switching to Now() solved issue, thanks

I made a rule, when a selection is made it for a choice field and is not blank, it sets a date field to today's date, i get red dashes around the field (indicating an error of some type), I am unable to clear the red dashes. I believe this is preventing me from submitting data to Sharepoint list. "The form cannot be submitted because ...

 I am trying to figure out a formula to use to validate a field entry on a SharePoint list form with the following criteria Letter, Letter - Number, Number, Number, Number - Number, Number, Number, Number. ...

 Thanks, the formula does work, I was putting it in the default value box instead of "The type of information in this column is:" section

 I need to add 2 years to a date field "D-SAACPCertificationDate" and display it in another field "D-SAACPExperationDate". I tried using the calculated field function in SharePoint Server list =DATE(YEAR([D-SAACPCertificationDate])+2,MONTH([D-SAACPCertificationDate]),DAY([D-SAACPCertificationDate])), but it errors. I ...

I have the functions working now. I was trying to create a new section to display the message. After I went home it occurred there is no reason to display the message in another section. So I put the message at the top of the Duplicates section. btw, I accepted a new SharePoint Content Manager position. I already know they do not use InfoPath, ...

Ok, got it working for the Start Date Field, when I display the values in XML, then I see the difference, I am using the substring function to look at the places I need it to look at. I am able to disable the submit check box, but I am also trying to get it to display a message, stuck on the logic for that part, but should be able to figure out ...

Thanks, got it working for most of the fields, has a problem with filtering on the Start Data and Class Size fields though

 Attached form. Step 1 view has a command button to check for duplicate records that match the following fields: CourseCd, Req_Type, Start Date, Primary Location and Berthing. After clicking the Check for Duplicates command button, the section is only supposed to show records matching these fields. After changing these fields, query does not ...

Ok, so I made a copy (template) to review all fields, rules etc and disable, remove one by one. As I was going through the rules, there was a rule to query when the id field changed. I believe this was done exploring possibilities to clear the fields after saving). Removed that rule and the form now saves the record with the title field and keeps ...