When asking a question in the forum that relates to formulas it is essential that you know the data types of all database fields involved. The basic 4 types are Number, Character, Date and Boolean. Each of these might have several subtypes like Currency, VarChar, DateTime, etc.
The essential thing to uncover is the data type as seen by Crystal Reports. Keep in mind that this may not be the same as the data type specified in the database. To know what Crystal is seeing, place the field onto the canvas (design screen), right click on the field, and select "Browse Field Data". This will show you sample values, and will also show you the data type as seen by Crystal Reports.
DataType is not the same as Format. This is especially true for dates, which can be formatted in any number of ways. This, however, has no effect on the data type of the underlying field.
So, when you ask a question about a formula, please include the data type of the fields involved in your post. If it is a character field include some sample values.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting Public classes and individual training. Guide to using Crystal in VB http://www.kenhamady.com/ tek2(AT)kenhamady.com