Timesheet - Start date must be a Sunday the week must include 1st or 16th - InfoPath Dev
in

InfoPath Dev

Office365 Alert - Sandbox has been deprecated in SharePoint Online.
Read more here.

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Timesheet - Start date must be a Sunday the week must include 1st or 16th

Last post 04-28-2017 08:52 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-20-2017 01:41 PM

    Timesheet - Start date must be a Sunday the week must include 1st or 16th

     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?  

     

     

  • 04-28-2017 08:52 AM In reply to

    Re: Timesheet - Start date must be a Sunday the week must include 1st or 16th

     Any chance you could attach a sample form with the work you've already done? Under the Options tab in a reply - I can take a look & maybe give you a hand. :)

    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2017 Qdabra Software. All rights reserved.
View our Terms of Use.