title: How to order dates in descending order when there are multiple years in data set
body: <p>I have an Integromat app pulling weather data with date-time and adding them to my sheet and then I use that data to make some graphs.</p>
  <p>The sheet in question can be found <a href="https://docs.google.com/spreadsheets/d/1QEw5CBno6j-2vIXDOFO7TqhA9m-rzNWsyVziw9SoQIs/edit?usp=sharing" rel="nofollow noreferrer">here</a>. The weather data is the <em>Data</em> sheet</p>
  <p>The issues are in GraphData!A18, GraphData!A31, and GraphData!A130. If I use</p>
  <p><code>=SORT(QUERY(Data!A:D,&quot;order by A desc limit 366&quot;),1,1)</code></p>
  <p>in GraphData!A130, it excludes data from the year 2022 as my date-time is in the format <code>12.31.2021 01:36</code>. I can't change how Integromat outputs data. I tried to use <strong>Format&gt;Number&gt;Custom date and time</strong> but it didn't change anything. So, how do I go about changing the formula to also include 2022 data?</p>