InfoPath Dev

So I have this form and when a drop down box selects a certain task it puts the date in the field.  The problem is that after I save it and reopen it to change the task that it is on it will add one day to the date, i.e. for today if I change the drop down from Create Timesheet to Pending, the pending date puts 08/29/12.  When I submit ...

Thank you so much for all your help!  I am sure I will be back for more, just different issues.  :)

So I tried to do Department and did everything (I think) you did, which is add a rule to set a field's value on the contractor name field.  Is there an issue that my field I am referring to, in this case, department, is a . ? I see you do not have that in your fields, maybe that is my issue all along.

You ROCK!! Thank you so much!  Can you tell me where I went wrong?  Also can I format the date and rate fields?

Okay Finished my tantrum, and I just can't let this go.  I have cleaned up my fields and put them in the order required.  Did not know I could do that.  Let's start over with the first issue.  My Contractor Name is a pull down from a secondary source field Name (Secondary Source Name: Info1) From the 2ndary ...

Thank you for your help, I think I am giving up on this.  Now it won't allow me to open once I changed my data.  That was one of the issues is that they took an excel sheet and exported it into SP and it was a text field, and entered in DD/MM/YY only sometimes.  So I exported the data, fixed the dates and imported it back into ...

So I grabbed a contractor, and it did not fill in the rate, but the contract end date populated all the dates in the SP list.  Attached is the screen shot in two pages.  It keeps going. 

There is a Sharepoint list with names and the dates they started and their end dates along with the rates.  I need to have the dropdown box pull from that list on the name and autopopulate the end date and rate.   I am trying to filter from their end date today and future.  That would be the active date I am trying to pull, but ...

Any help would be greatly appreciated.

I have been doing research to try and get this to work for 2 weeks and it just won't work no matter what I do, even recreating the same form that the example is showing.  I am doing a data connection with a drop down box and need that to populate the names depending on the active date from today and forward.  Also from the ...