datediff ("ww", cdate(invoice_date), currentdate)

 

When I add it to my report I get an error:

 

      "Dates must be between year 1 and year 9999."

 

In the DB2 DB it has the invoice field as a int. (20090123).

 

How can I work around this to get the number of days between these to dates?  Do I have to convert the invoice date in Crystal?  If so how?

 

Apprciate the help.

I still get the error, but after playing around with what you send I did the following input and and output:

 

        input:     left(totext(invoice date),10)

 

        output:  20,090,922

 

How do I remove the commas?