title: “Type DATE is not a defined system type.”
body: <p>Right now I'm developing a program but had an issues with </p>
  
  <blockquote>
    <p>Type DATE is not a defined system type.</p>
  </blockquote>
  
  <p>I wrote my queries with SQL Server 2008 on local and it run very well, but when change to live server, it went wrong and prompt above error. For live server my company using SQL Server 2000.</p>
  
  <p>Below is my query :</p>
  
  <pre><code>SELECT DISTINCT 
      CONVERT(varchar, A.MONTH) + '/' + CONVERT(varchar, A.YEAR) AS MonthYear
  FROM
      XXX1 AS A 
  LEFT JOIN
      XXX2 AS B ON A.EMPLOYEE_NO = B.EMPLOYEE_NO 
  LEFT JOIN
      XXX3 AS C ON A.EMPLOYEE_NO = C.EMPLOYEE_NO 
  LEFT JOIN 
      XXX4 AS D on A.FREQUENCY = D.FREQUENCY 
  WHERE
      (A.EMPLOYEE_NO = '710049') AND (A.FREQUENCY = '9') 
      AND ((day(getdate()) &gt;= DAY(d.TRANS_DATE) OR 
            month(getdate()) = MONTH(d.TRANS_DATE) OR
            YEAR(getdate()) = YEAR(d.TRANS_DATE))
           OR (month(getdate()) - MONTH(d.TRANS_DATE) &lt;&gt; 0 
           OR day(getdate()) &lt; DAY(d.TRANS_DATE)))
  </code></pre>
  
  <p>Any solutions?</p>