Contents of the Format/Date Time Dialog Box

Use this dialog box to format date and time settings. This dialog box is used in both the Reporting and Proposals applications.

Format Options

If you select a column that is date or time, you can specify the format for that column.

Field Description
Type Select one of the following date options:
  • Short Date: By default, this option displays the month, day, and year with the month expressed as a number. The month, day, and year are separated by the date separator in the Date Options group box (10/29/2019, for example). The order of the elements of the date is determined by the Date Order field (month/day/year or day/month/year, for example).
  • Medium Date: By default, this option displays the month, day, and year with the month spelled out. You set the sequence of the date elements in the Date Order field (October 29, 2019, for example or 29 October 2019).
  • Long Date: By default, this option displays the day of the week spelled out first, then the other date elements in the order of the Date Order field (Monday, October 29th, 2019, for example).
  • Short Date and Time: This option displays the Short Date plus a space and the time (10/28/2014 11:30:21, for example).
  • Time: This option displays the time only.
Apply To Specify whether the format should apply to all fields or to this column only.
Insert In Proposals, click this option to display the record with all placeholders inserted. If you inserted fields in a grid, each grid will have its own section of placeholders.