Date Fields

The Date field is used to provide the user with a way to capture date information.  

Date Field in Palette Window

Define the Date Field

Drag and drop the Date field from the Palette window onto the Fields Pane.  The Field Properties window will open, which provides the means for configuring the field.  Enter the field information such as field name, display name, etc., by clicking in the field and typing the information.  

Determine How To Calculate Dates

Specific dates can be calculated using the Calculated property in the FieldProperties Window.  Click the button to the right of that property and the Date Field-Calculated window will open.  Select the type of calculation, the method and then enter any necessary statements in the box provided.  The Test button is an additional tool that can be used to run through a SQL statement to see if any errors occur.  Select OK when the calculated information is complete.

Calculated Option in Field Properties and Date Field-Calculated Window