Calculate the difference between a date and the current date
<p>I am creating a program with C# which interfaces with a Microsoft Access Database.  My current task is to capture the date/time an entry was created and calculate the difference between the stored value and the current date and display that in a cell.  What I am not sure about is whether to do the calculations in C# and then store them in the database or store the information in the database first and then perform the calculations with SQL.  </p>

<p>I also need to track how long a unit has been classified under a specific status code.  I need to track the date/time the status code was changed and calculate the difference in days between the date the status code was changed and the current date.  </p>

<p>For example...if Unit xyz is a had its status code changed on 3/5 and the current date is 3/8...I want it to show that it has been in limbo for 3 days.</p>

<p>The whole purpose of this is to determine where the bottlenecks are in the production process.</p>

<p>I am using Visual Studio 2015 Professional and Microsoft Access 2010.  The database is stored as a .mdb file.</p>

<p>I am sorry if this is a bit confusing.  I will be happy to edit my question, add additional details, and/or provide clarification to help answer this question.</p>

<p><b>Edit For Code</b></p>

<pre><code> private void button1_Click(object sender, EventArgs e)
    {
        DateTime startDate = new DateTime();
        DateTime a = DateTime.Now;
        startTimeTextBox.Text = a.ToString();
    }

     private void button2_Click(object sender, EventArgs e)
    {
        DateTime b = DateTime.Now;
    }
</code></pre>

<p>These are the only two bits of code that I have tried.  I have also tried doing the calculations in Access with Now() - StartDate with limited success.</p>