title: Crystal Reports : Bad Date format string error
body: <p>I am a newbie to crystal reports, I have a crystal report for which I have a data source from which I am using some fields on to the report.</p>
  
  <p>Crsytal Report Name : InventoryReport</p>
  
  <p>Data Source : I am giving Stored Procedure -- GetInventoryData</p>
  
  <p>Fields :  ItemID, ShippedDate,  ItemName</p>
  
  <p>I have to get all items which are shipped in between  FromData and ToDate of ShippedDate, so I am using formula   {GetInventoryData;1.ShippedDate} in {?FromDate} to {?ToDate}</p>
  
  <p>dataType of Shipped Date is String and I have to convert to Date as it needs to be compared but I am having issues in that... </p>
  
  <p>ShippedDate value will be : 2011-04-19 16:02:14.0000000</p>
  
  <p>I have to convert at crystal reports side only..</p>
  
  <p>Please help me how can I cast it to date</p>