The format of a Date field is, by default, the same as the date format set up for the computer you work on (Control Panel>Regional Settings>Date).
You can change the date format for your field:
If you choose the System short date and System long date values, the date field is formatted according to the format specified on the Windows control panel (Regional Settings>Date). In order to set up your own date format, select the Custom format value in the Type field and then enter the user format as set forth below in the Format field:
Description | How to get this |
---|---|
Date without leading zeroes | Enter one character - d for day, y — for
year and M — for month. For example, the date June the 5th 2001 will look as follows in the d.M.y format - 5.6.1. |
Zeroes before one-digit dates | Enter two characters, dd for day, yy — for
year and MM — for month. For example, the date June the 5th 2001 will look as follows in the dd.MM.yy format - 05.06.01 |
Four-digit year | Enter yyyy for year. For example, the date June the 5th 2001 will look as follows in the dd.MM.yyyy format - 05.06.2001 |
Month acronyms | Enter MMM for month. For example, the date June the 5th 2001 will look as follows in the dd.MMM.yyyy format - 05 Jun 2001 |
Full month names | Enter MMMM for month. For example, the date June the 5th 2001 will look as follows in the dd.MMMM.yyyy format - 05 June 2001 |
The field is a list of values you may select. You are advised to use this field type if the field info is a limited set of choices. A newly created field of List type has its value list empty. In order to add a value to the list:
Note: Each value must be added to the list by clicking the Add button.
The default way of displaying a checkmark field is a "check sign". You may select another sign with meaning "checkbox checked". It may be a cross, a dash, etc: