I am working on a Semi-Monthly Timesheet form and having some issues with the start week. The form will be filled out for 1-15 and 16- end of month.
Here are there requirements:
- Select start of week by using the Date Picker
- The start date must be a Sunday
- The week must contain the 1st or 16th.
I have a date picker, then I have days of the week below it in a table. The table is in a section and I want to hide the section until a valid week is entered. People tend to not put the correct date in and I need validation to prevent errors.
I am having issues getting the rules setup. Just when it looks like it starts to work, I always find a loop hole to bypass the validation. Sometimes I pick a Sunday and it doesn't have a 1 or 16 but it still shows. Sometimes I pick a valid week and it doesn't show.
I have setup 7 fields, one for each day of the week, to pull the day of the week from the date picker. I have rules on each one to determine if it contains a 1 or 16.
I have another field to determine if the start date is a Sunday. If it equals 0 its a Sunday. If it doesn't equal 0 then hide the timesheet.
Has anyone done something like this before? Maybe I need to take a new direction?