Bad Date-Format String

[kozman]

I'm trying to generate number of days between two dates. I keep receiving "bad date-format string". Even a simple formula kicks out the error.

{order.dateorderplaced} - {order.dateordertaken}

Any suggestions?

Thanks

 

[kenhamady]

What database adn what datatype are these fields?
Ken Hamady

http://www.kenhamady.com/

 

[ziggs]

Also, are you using Crystal Reports 7 or lower? I used 7 and had that problem. When I upgraded to 8 a few weeks back, it worked.