title: Number of days between current date and date field
body: <p>I have this problem if anyone can help.
  There is a field <code>(date)</code> in my table <code>(table1)</code> that is a date in the format <code>3/31/1988 (M/D/y)</code>, and my necessity is to define how many days have passed since that date.</p>
  
  <p>I have tried to give this instruction</p>
  
  <pre><code>SELECT DATEDIFF(CURDATE(), date) AS days
  FROM table1
  </code></pre>
  
  <p>But it gives back 'null' and I think this happens because the two date formats are different (CURDATE() is YMD.....</p>
  
  <p>Is it correct? can anyone help me?
  Thank you in advance</p>