Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Urgent

Status
Not open for further replies.

mazhar

IS-IT--Management
Aug 13, 2000
8
US
Hi Malcolm,

Again I am coming to u to get resolved a doubt..

In selection formula or Formula Fields if i compare the date with some hard coded value or selected text box value which i am passing through VB it is giving "Error in formula".Please give me the answer to this.
Thank u
Mazhar [sig][/sig]
 
mazhar,

Crystal uses a different date syntax, so if you are passing a formula to be evaluated by Crystal, you have to use the following syntax:


{Date.field} > Date(2000,9,15)

The key is if the formula will be processed by your application, say in VB, or by the Crystal Report. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href= Reports Taining by Ken Hamady</a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top