Field Type
The property of a field that determines what kind of data it contains. Monarch Classic supports character, date/time, numeric, and memo field types. For some field types, such as date/time ones, there are several available formats. The following chart displays the various field types and their available formats.
Field |
Description |
Character – General |
Displays values as a string of up to 254 characters. |
Date/Time – General |
Displays date as "yyyymmdd" if there is a non-zero datepart. Displays time as "hh:mm:ss" if there is a non-zero time part. If both the date and time parts are zero, this format shows "00:00:00" (i.e.,midnight). |
Date/Time – Short Date |
Shows the date using the currently-configured Windows Short Date setting (e.g., April 16, 2003 might be represented as “04/16/2003”). Does not show the time. |
Date/Time – Long Date |
Displays dates as specified by the Windows Long Date setting (April 16, 2003 might be represented as “Wednesday, April 16, 2003”). Does not show the time. |
Date/Time – Short Date & Time |
Shows the date using the currently-configured Windows Short Date setting and displays time (if present) using the currently-configured Windows Time setting (April 16, 2003 at 11:03 in the morning might be represented as 04/16/2003 11:03 AM). If both the date and time parts are zero, this format shows midnight, as represented by the current Windows Date and Time display configuration. |
Date/Time – Long Date & Time |
Shows the date using the currently-configured Windows Long Date setting and displays time (if present) using the currently-configured Windows Time setting (April 16, 2003 at 11:03 in the morning might be represented as Wednesday, April 16, 2003 11:03 AM). If both the date and time parts are zero, this format shows midnight, as represented by the current Windows Date and Time display configuration. |
Date/Time – Time |
Displays time as "hh:mm:ss" if there is a non-zero time part. Does not display the date. |
Numeric – General |
Displays numbers in their most compact form (e.g., 123.45). |
Numeric – Thousands |
Displays numbers with a thousands separator, e.g., 1,234.56. The separator and format uses the currently-configured Windows Number formats. |
Numeric – Currency |
Displays numbers as specified by the currently-configured Windows Currency settings (these settings specify how numbers should be represented in the local currency, e.g., $1,235) |
Numeric – Percentage |
Displays numbers as a percentage of 1 (i.e., 1 is represented as 100%). |
Numeric - Time Span |
Displays elapsed time in seconds in HHHH:MM:SS.sss format in both tables and summaries. For example, in a Time Span field an elapsed time of 70 seconds (i.e., 1 minute and 10 seconds) would be displayed as "00:01:10". |
Memo - General |
Displays values as a string. Memo field length is determined by the data in the field, with a maximum length of 64KB. |