title: Subtract a date to currentDate() in Azure Data Factory
body: <p>My final goal is to create a derived column in Azure Data Factory (in a dataflow), using 2 dates as following.</p>
  <p>I would like to subtract a date named <code>MinWADAT</code> (in <code>integer</code> format, like '20120203') from <code>currentDate()</code> (returning for example '2021-10-05'). The result should be in days unit.</p>
  <p>I try to use the following function:</p>
  <p><code>toDate(MinWADAT)-currentDate()</code></p>
  <p>but the result is an empty column.</p>
  <p>Can you help me?
  Thank you in advance.</p>