title: Power Query Expression.Error: The Date value must contain the Date component. Details: 43831
body: <p>I am using power query in Excel. I have a date column with date starting in 1/31/2015 and ending 1/31/2022.  I have the below line of code that works just fine.</p>
  <pre><code>...
  #&quot;Changed Type&quot; = Table.TransformColumnTypes(#&quot;Renamed Columns&quot;,{{&quot;Reading&quot;, type number}, {&quot;EM_Date&quot;, type date}}),    
  #&quot;Filtered Rows&quot; = Table.SelectRows(#&quot;Changed Type&quot;, each [EM_Date] &lt;= #date(2021, 12, 31)),
  ...
  </code></pre>
  <p>Now if I change the code just slightly like below It stops working and gives me an error. &quot;Power Query Expression.Error: The Date value must contain the Date component. Details:     43831&quot;</p>
  <pre><code>...
  #&quot;Changed Type&quot; = Table.TransformColumnTypes(#&quot;Renamed Columns&quot;,{{&quot;Reading&quot;, type number}, {&quot;EM_Date&quot;, type date}}),    
  #&quot;Filtered Rows&quot; = Table.SelectRows(#&quot;Changed Type&quot;, each [EM_Date] &gt;= #date(2021, 1, 31)),
  ...
  </code></pre>
  <p>How do I fix this error?</p>