Adding a DateTime protperty as a column to the SalesLogix web lookup control

In the SalesLogix web client if you want to add a column that is a DateTime column to a lookup control’s lookup dialog you need to define it in a specific way in order to have the lookup make sense for end users. 

If you define the lookup column as a PropertyType of System.DateTime, when a user attempts to search, the system will not interpret the user input correctly unless it is entered exactly as YYYYMMDD.  If you format it as something like MM/DD/YYYY, the system will convert that to a different value during the search.

The way you want to define things are:

• PropertyType= System.String
• PropertyFormat=”DateTime”
• PropertyFormatString=”MM/dd/yyyy”