Syntax on Date Expressions

Overview

Determine the correct syntax for a data expression when doing a calculation.

Details

Within TIER Design, the Validation window on the Object Inspector contains the correct syntax for Date Expressions and more.

Steps

1. On the Object Inspector, click the ellipse button to open the Validation window.
2. Navigate to the Date Expressions and click to display the list of expressions. 
3. Highlight an expression and hover over it. The syntax and description of what the expression will return is displayed. 
   Expressions can be used for a validation if double clicked. For example, say you need to calculate the beginning month date based off of the date of service on a Progress Note. Get the syntax from the Validation window StartofMonth( :DateService ).
4. On a TierEdit control, enter the syntax on the Calculation property. For this example, :DateService is the control that the datetime is based off of. Be sure to set the FieldType to match the returned data. In this case the type can be Date or Datetime.

 Remember, you are not setting up a validation but only getting the correct syntax from the Date Expressions that display within the Validation window.

See the attached pdf for the entire Tidbit and accompanying screen shots.