Filtering with date types

How do I set an expression to compare date values in the Filter property?

Halcyon uses the 'standard' xBase method of representing dates in expressions.

You can surround a date with braces ('{' and '}') to show that it is a Julian Date. For example {12/31/1999} is translated to a Julian Date instead of a string literal.

You can also use the CTOD() function. In this case the date is entered as a string value and converted by the CTOD() function to a Julian date.

Thus, if BIRTHDATE is a date field in the database, both these expressions would work:

BIRTHDATE > {01/01/1980}

BIRTHDATE > CTOD('01/01/1980')