Date Columns

Dates are an essential part of every business process, probably your database may contain due dates, delivery dates, dates of payment, clients’ birth dates, etc.

If a column comprises the data that don't look or behave the way you want, you may edit column General Properties and the properties defined by the column type.

Columns of the Date type comprise a calendar button that allows database users choose a date and helps to avoid any other kind of data entry. Using Date column properties you may change the date format or set the default date to be today’s date.

Date Options

Column Property

Description

Format

This property allows a user to specify a format in which the date value will be represented. The following options are possible: