title: Data Studio "Date Range Control" doesn't working when date column with empty values
body: <p>I have two different DateTime columns with the same format date. &quot;Created_datetime&quot; is well recognized by data studio as a date). &quot;paid_datetime&quot; will contain some empty value, Data Studio does not recognize it as date but as text. Data table shown below.</p>
  <p><a href="https://i.stack.imgur.com/gREJ4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gREJ4.png" alt="Example data" /></a></p>
  <p>After my research, I apply &quot;TODATE&quot; function as
  TODATE(paid_datetime, &quot;%d/%m/%Y %H:%M&quot;, &quot;%d%m%Y%H%M&quot;)
  <a href="https://i.stack.imgur.com/EXrvD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EXrvD.png" alt="TODATE FORMULA" /></a></p>
  <p>But after applying the filter &quot;Date Range Control&quot;, the &quot;total_selling&quot; and &quot;grand_total&quot; did not match the correct results. May I know any solution for this issue?
  <a href="https://i.stack.imgur.com/nGtyY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nGtyY.png" alt="enter image description here" /></a></p>
  <p>Appreciate for help! Thank you! Detail Provided below:</p>
  <p>1.)Public Editable DataStudio Report Link:</p>
  <p><a href="https://datastudio.google.com/reporting/a3067f59-b01a-411c-aab8-4f930495cf2a" rel="nofollow noreferrer">https://datastudio.google.com/reporting/a3067f59-b01a-411c-aab8-4f930495cf2a</a></p>
  <p>2.) Example Datatable</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">id</th>
  <th style="text-align: center;">total_selling</th>
  <th style="text-align: center;">grand_total</th>
  <th style="text-align: right;">paid_datetime</th>
  <th style="text-align: center;">Created_datetime</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">1</td>
  <td style="text-align: center;">10</td>
  <td style="text-align: center;">11</td>
  <td style="text-align: right;">23/6/2022 23:22</td>
  <td style="text-align: center;">17/3/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">2</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  <td style="text-align: right;"></td>
  <td style="text-align: center;">17/3/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">3</td>
  <td style="text-align: center;">12</td>
  <td style="text-align: center;">14</td>
  <td style="text-align: right;">20/6/2022 20:22</td>
  <td style="text-align: center;">17/4/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">4</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  <td style="text-align: right;"></td>
  <td style="text-align: center;">17/4/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">5</td>
  <td style="text-align: center;">12</td>
  <td style="text-align: center;">14</td>
  <td style="text-align: right;">10/6/2022 13:22</td>
  <td style="text-align: center;">17/4/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">6</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  <td style="text-align: right;"></td>
  <td style="text-align: center;">10/4/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">7</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">5</td>
  <td style="text-align: right;">5/4/2022 21:22</td>
  <td style="text-align: center;">10/4/2021 14:34</td>
  </tr>
  <tr>
  <td style="text-align: left;">8</td>
  <td style="text-align: center;">11</td>
  <td style="text-align: center;">21</td>
  <td style="text-align: right;">1/6/2022 2:33</td>
  <td style="text-align: center;">30/5/2022 14:44</td>
  </tr>
  <tr>
  <td style="text-align: left;">9</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  <td style="text-align: right;"></td>
  <td style="text-align: center;">30/5/2022 14:44</td>
  </tr>
  </tbody>
  </table>
  </div>