If you need your visitors to pick a date in a form, use the calendar widgets. This makes it easier to locate the right date, and reduces the risk of errors considerably.
There are many situations where you may need a visitor to provide a date in one of the input fields of a web form. On the surface it may be adequate to use a simple text field for this, but unfortunately there are numerous data validation issues with date fields:
And there’s probably more you need to think of, to properly validate a date that has been entered free-form in a text field. What date is 09-10-11? Let’s just say that using text fields for dates is a bad idea.
To help solve this problem, SpreadsheetConverter provides two different kinds of Calendar widgets. If you use one of these widgets, you will make it much easier for the user to pick the right date, e.g. since the calendar also shows weekdays. A calendar also makes it easier to count from one date to another. The widgets ensure that any date picked from the calendar is valid, and formats it correctly for the recipient of the electronic web form using the regional settings.
The calendar widgets do not return the selected date as text. Excel stores dates as sequential serial day numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900. The date returned by the calendar widgets is in the form of an Excel serial number.
You can pass data into any named field in a form by providing it in the link, e.g.
In the example above, the serial number for January 1, 2008 is sent from the link into a field named “date” in the form. If this field contains a calendar widget, it will open on January 1, 2008.
Both Calendar widgets style share the same set of widget properties:
*The default value of a calendar field is empty. To provide a default date, enter a date or Excel day number into the cell. If you enter a date it must be formatted according to your computer’s regional settings, so that Excel converts it into a serial number automatically.