The Start Dateand End Datecells restrict data in FDcolumns to specific dates. This restriction is useful for daily or weekly sales reporting, cash analysis needs, and other date-sensitive reports.

You can enter a specific day of the period. For example, you can enter 3to indicate the third day of the period. The ability to add a specific day of the period adds flexibility because you do not have to select the actual dates again when you run the report for the next period.

Enter a starting and ending date

  1. In Report Designer, click Column Definitionsin the navigation pane, and open the column definition to modify.

  2. Double-click the Start Datecell in an FDcolumn, and then select a date on the calendar.

  3. Double-click the End Datecell for the same FDcolumn, and then select a later date on the calendar.

Example

The following entry is valid.

Start Date

1

16

4/1/2017

End Date

15

30

4/30/2017

The following entry is not valid.

Start Date

04012017

End Date

04302017

See Also