title: Datediff formula in Crystal Report result wrong calculation
body: <p>Here I'm using the following formula in my crystal report to find the aging of a product. I have taken my manufacturing Date as Default_Date and Date to compare as current date.</p>
  
  <p><code>datediff("d",CDate({Yarn_Packing_Weighment_Entry.Default_Date}),CurrentDate)</code></p>
  
  <p>The formula have no errors but when date is from 1st to 12th - The difference results are wrong </p>
  
  <p><a href="https://i.stack.imgur.com/tna85.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tna85.jpg" alt="Date compared - Current Date ie 30-07-2018"></a></p>
  
  <p>and after 13th to 31st - </p>
  
  <p><a href="https://i.stack.imgur.com/3welC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3welC.jpg" alt="Which shows correct calculation after 12th"></a></p>
  
  <p>DOP Column date is which I'm comparing with Currentdate. A screenshot is attached </p>
  
  <p><a href="https://i.stack.imgur.com/GM6Gd.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GM6Gd.jpg" alt="D1 Column is the date which results DOP converted to Cdate and D2 is CurrentDate"></a></p>
  
  <p>Please advice me where I'm wrong. Thanks in advance</p>