Date Input Box Properties dialog box – Date Input Box Settings tab
Develop > Database > Field > Date Input Box
This dialog box is used to add or configure a date/time input field in an input block or a modification block.
Target field
Select the database field corresponding to the date input field. The drop-down menu lists all the eligible fields among those you selected in the Database Fields step of the Database Wizard. Only fields that have the date data type are eligible.
Although it is possible to type a field name into the text box, do not enter the name of a non-date field. If you do so, the input form will not work.
Default value
If the date input field is in a modification block, you can specify a default value for the field to be supplied from an date-format database field among the fields you selected in the Database Fields step of the Database Wizard. The value contained in that field for the selected record will be used as the default value of the date input field when the document is displayed in a browser.
Date format
Specify the date/time format. Use “yy” for the year, “mm” for the month, “dd” for the day, “hh” for the hour, and “mi” for the minute. Use the drop-down menu to select from several common formats. After selecting a format in the menu, you can edit it in the text box. If you don’t want to include the time, remove “hh:mi”. If you set the date format to “hh:mi”, the current date will still be sent to the server.
Example date formats:
mm/dd/yy hh:mi
yy-mm-dd