title: Adding condition on a date field in PDI
body: <p>I am using PDI to extract data from the database. I am having a problem where i cannot add a condition in date field as it always gives error.</p>
  <p>I have tried following ways</p>
  <pre><code>{news_date: {$gte: ISODate(&quot;2020-12-30&quot;)} }
  {news_date: {$gte: new Date(&quot;2020-12-30&quot;)} }
  </code></pre>
  <p>nothing is working and I am always getting errors. Any help in this regard will be much appreciated. How do I pull data from mongo DB filtered on Date?</p>
  <p>following is the error i am getting on preview which also makes no sense to me
  <a href="https://i.stack.imgur.com/QG3RT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QG3RT.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/t9osb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t9osb.png" alt="enter image description here" /></a></p>