I created a formula for each of the three fields @DateWanted: CDate({JC10.DATE_WANTED}) etc.

 

When I subtract DATE_WANTED - DATE_ORDERED everything works fine. When I try to subtract DATE_SHIPPED - DATE_WANTED i get a "bad string error" because some of the values in the DATE_SHIPPED are null (not shipped yet).

 

How can I fix this issue? I tried to use an If statement but obviously I did something wrong. Can someone help?

 

Thanks so much.

 

Rick

 

(p.s.: I hope I haven't posted twice. If so I apologize but I could not see my first posting).