I have create a form in infopath and I need someone to complete the calcucation.
TimeIn -TimeOut = TImeWorked (9:00 AM - 5:00 PM = 8 hours worked)
I have a field called "PayPeriodStartDate" that user choose from a drop down menu, I need to make sure that in the repeating table that has a field call "PayPeriodDate" that the user is can only choose dates that are in two weeks of the PayPeriodStartDate or they get a validation error.
I have a drop down menu that contains sites, I need for each site to calculate hours worked at a certain site. I have attached the InfoPath form to give you a look at the scope of the work.
Any codeing needs documentation
I have total of 5 list (Staff List, Pay Periods, Time Intervals and Pay Periods)
Pay Periods has a calculated column named StartDate that is populating a drop down list in the infopath named PayPeriodStartDate
The issue that I'm having is that I have I had to use this forumla (=TEXT([Start Date], "mm/dd/yyyy") for the StartDate calcuated column
because I need the date to be in the "mm/dd/yyyy" format.
This means that the data is passed as a string and I run into a problem when I try to enforce a rule on a date field named PayPeriodDate that will make sure the user in within 2 weeks of the PayPeriodStartDate
the user picks 10/1/2011 for a PayPeriodStartDate that means that the date has to be between 10/1/2011 and 10/14/2011 or they will get a vaildation error
The next issue is that I have two drop down time fields called TimeIn and TimeOut and another text box field named hours that will show the results of the time a user worked.
TimeIn = 9:00 AM TimeOut = 5:00 PM then hours = 8
I can't figure how in infopath to calculate the hours field and I had to manually enter the time in TimeIn and TimeOut and I would rather they get that information from a sharepoint list.
Lastly I have several field at the end that give a subtotal for hours worked at each site and overtime for week 1 and week 2. they have to calculate correctly based on the user input.
I have attached the the infopath form and excel spreadsheets that contain the sharepoint list info