Date/Time Format
You can use the Date/Time Format property to specify the layout and content of the Date/Time Control type. The table below shows the different components that can be combined.
dd
Indicates that an input box will be entered allowing the user to enter a two-digit day. For example, 23.
dd-
Indicates that an input box will be entered allowing the user to enter a two-digit day. If the date is unknown the user may enter UN for ‘unknown’. For example, 23.
mm
Indicates that an input box will be entered allowing the user to enter a two-digit month. For example, 5.
mm-
Indicates that an input box will be entered allowing the user to enter a two-digit. If the date is unknown the user may enter UN for ‘unknown’.
MMM
Indicates that a three-digit month will be entered with the use of a drop-down menu. For example, JAN, MAY.
MMM-
Indicates that either a three-digit month will be entered or UNK for ‘unknown’ with the use of a drop- down menu. For example, JAN, UNK.
yy
Indicates that an input box will be entered allowing the user to enter a two-digit year. For example, 07, 12.
yyyy
Indicates that an input box will be entered allowing the user to enter a four-digit year. For example, 2007, 2012.
hh
Indicates that an input box will be entered allowing the user to enter a two-digit hour will be entered in a 12 hour clock format. For example, 01, 12.
rr
Indicates that an input box will be entered allowing the user to enter either AM or PM. For example, AM,PM.
HH
Indicates that an input box will be entered allowing the user to enter a two-digit hour in 24 hour clock format. For example, 01, 15.
nn
Indicates that an input box will be entered allowing the user to enter a two-digit minute. For example, 05, 58.
ss
Indicates that an input box will be entered allowing the user to enter a two-digit second. For example, 03, 54.
Sample Formats
The following table contains several example formats which can be used within the Date/Time property.
Date/Time Defaults
The table below contains the default for each Datatype.