title: comparing dates with sharepoint
body: <p>I am trying to compare the date of my Last B Service + Service interval months to todays date in Sharepoint. But it is giving me an error.</p>
  
  <pre><code>=IF(DATE(YEAR([Last B Service]),
  MONTH([Last B Service])+[B Service Monthly Interval], 
  DAY([Last B Service])),"D")) &gt;= NOW(), 0, 1)
  </code></pre>
  
  <p>I add B Service Monthly Interval to the Months section in the Date variable, then try and compare it to NOW() (todays date) to make this example easier, i have changed the result to 0 and 1 (i ahve also tested this and it returns an error)</p>
  
  <p>Can you see whats wrong with that code?</p>