Specifically, i'm looking for a way to manipulate the date.  In our database, our date is stored in a julien number format.  I created a parameter within the command, but it is created in a date format.  The easiest solution to this is to convert the parameter date format to the julien by using the DATADIFF command, but the command does not seem to recognize that expression.

 

Any ideas?

 

GLDGL>=(111,001+DATEDIFF('d",#2011/01/01#,{?Start Date}))

 

GLDGL is the field from the database stored in julien.

{?Start Date} is the parameter putting it in a date format.

 

When i put this into crystal itself, it work perfectly, but when i try to put it into the command i get the following error:

 

Failed to retrieve data from database.

Numeric constant 01# not valid. [Database Vender Code: -103]

 

I tried different things like changing the # to a ', but the error just changes to:

 

DATEDIFF in *LIBL type *N not found. [Database Vender Code: -204]

 

Any ideas?