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.

Columns of the Date type comprise a calendar button that allows database users to choose a date and helps to avoid any other kind of data entry.

Date Field.png

The Date format is defined automatically and depends on the Language and location settings specified in a user profile. In case a user doesn’t have a profile or when a notification with Date column value is sent to a person who is not a database user, the Language and location settings specified in the database properties are taken into account to determine the date format.

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.

General Properties:

You can set the Today option in the General Properties and the today date value will be inserted by default in this Date field, when a new record is created.

Date General Properties.png

Properties defined by the column type:

Using Date column properties, you may change the date format according to your needs.

Date Column Properties.png

Date Options

Column Property



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

  • Short Date
  • Long Date
  • Month Day - month preceding day, for example, November 24
  • Year Month - month preceding year, for example, January 2007


When the Help text property is filled in, the question mark is displayed near the field name on the View/Edit form. If you point to this question mark, the pop-up with a tip or a help text message will be shown.

Next: Time Columns