title: getting the items about to expire 3 months from now in vb.net
body: <p>i'm currently doing my project and i dont know the code for getting the items that is about to expire 3 months from date today. anyone there who can help me about this? thanks</p>
  
  <pre><code>Function popCat()
      Call populateOnGrid(da, dset, _
        "Select * from tblItems where cdate(Expiry_Date)&lt;&gt;cdate('" &amp; Date.Today.ToString("MM/dd/yyyy") &amp; "') order by Category,Item_Name", "tblItems", dgExpiry)
      lblrecFnd.Text = totRec &amp; " Records/s found"
      Call formatGrid()
      Return True
  End Function 
  </code></pre>