I need to calculate the days between date_wanted - date_ordered and date_shipped - date_ordered.

 

In Crystal XI I created three formulas @date_wanted (CDate({JC10.DATE_WANTED}), etc.

 

date_ordered and date_wanted are working just fine but date_shipped is giving me  a "Bad date format string" error. The only thing I can think about is that date_shipped has empty records. If this is the problem, how can I take care of it? In other words, if I haven't shipped one or more items how can I tell the system to give me the difference between date_wanted - date_ordered but not date_shipped - date_ordered?

 

thanks in advance.