General

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

stormcat73 — Wed, 30 Jan 2013 14:15:14 GMT

Hi Jimmy what if my pay period is 1-15 and 16-30-31.

Can your example be modify for this? if so what

Is it possible to have a calender that auto populate the days for that pay period.

thanks

Zee

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Jimmy — Thu, 27 Dec 2012 18:52:34 GMT

You're very welcome.

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Bnighgrow — Thu, 27 Dec 2012 18:46:34 GMT

That works absolutely perfect!

I was currently building it using rules... Talk about tedious.

I have never dealt with using an External XML Source seems very benefical. I will implement this, and I appreciate the lesson. Thank You.

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Jimmy — Thu, 27 Dec 2012 18:38:49 GMT

Please give the attached form a try. I have an XML data connection querying a resource file in the form to get the date values, but you might want to consider storing the file somewhere external to the form so that you can modify it without republishing the form.

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Bnighgrow — Thu, 27 Dec 2012 17:54:02 GMT

Yes that is correct. I have been thinking about how to go about doing this, and I figured the best way would be...

Example: Have the Start_Date_DropDown with 5 pay dates. After the user selects a date (for this example we will say date number 3) display the End_Date_DropDown.

The only values that should be displayed in End_Date_DropDown should be dates 4, 5.

What do you think?

Brandon

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Jimmy — Thu, 27 Dec 2012 17:33:27 GMT

So to clarify, you have a predetermined set of dates you want to provide, and there are fields called Start Date and End Date for which you would like the user to select values. Then you would like to determine the number of pay dates between them. Is that correct?

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Bnighgrow — Wed, 26 Dec 2012 18:15:35 GMT

Well I have the set dates which should only be available. (For Example: Jan 2, 2013, Jan 16, 2013, Jan 30, 2013, Feb 13 2013... June 18, 2013) For my form I would have a Start Date: & End Date: and hopefully another field that displays the number of pay periods in between.

Example would be: Start Date: Jan 2, 2013 //// End Date: Feb 13, 2013 Pay periods: 4.

Any insight on dropdown box method would be great.

Brandon

Re: Modifying the Date/Calendar Functionality for Bi-Weekly

Jimmy — Wed, 26 Dec 2012 18:10:00 GMT

There isn't a way to manipulate the date picker the way you describe, but is there a limit to the number of dates you want to make available? Perhaps a dropdown box would do the job in this case.

Modifying the Date/Calendar Functionality for Bi-Weekly

Bnighgrow — Wed, 26 Dec 2012 17:36:11 GMT

Hello, I am trying to accomplish something that might not be possible and would like some insight on it. I have a form that will take donations, and I have two payment methods. Credit Card, and Payroll deductions.

With the payroll deductions I need the date control to just display or have highlighted every other Friday (Bi-Weekly) and have the other dates in the month greyed out or unclickable. Is this possible with custom coding?

Thank You in advance,

Brandon