Google sheets query date range between today and the end of next month
<p>I have a google spreadsheet that queries data on another spreadsheet.  I need to return Col1-3 if the date in Col1 >= toDate(now()) and Col1 &lt;= "the last day of next month".</p>

<pre><code>=ArrayFormula(query(ImportRange("1YHvYS1-rc1n56CeVeBynZRP6YCtTTyHkVhdu-Wa8E4s=en#","Alt Single Signup!A1:Z200"),"select Col1, Col2, Col3 where (Col1 &gt;= toDate(now()) and Col1&lt;= "the last day of next month")"))
</code></pre>

<p>I am not sure how to get "the last day of next month". Is there a simple way to figure this out?</p>

<p><em>EDIT</em>
Using the answer below I ended up dropping it in an if stmt to check todays date to pull either till the end of this month or next month. </p>

<pre><code>=if(Day(today())&lt;27,query(ImportRange("1YHvYS1-rc1n56CeVeBynZRP6YCtTTyHkVhdu-Wa8E4s=en#","Alt Single Signup!A1:Z200"),"Select Col1,Col2,Col3 Where toDate(Col1) &gt; date '"&amp; TEXT( Today() , "yyyy-MM-dd" ) &amp; "'And toDate(Col1 ) &lt;= date '"&amp; TEXT( EOMONTH( Today() , 0) , "yyyy-MM-dd" ) &amp; "' "),query(ImportRange("1YHvYS1-rc1n56CeVeBynZRP6YCtTTyHkVhdu-Wa8E4s=en#","Alt Single Signup!A1:Z200"),"Select Col1,Col2,Col3 Where toDate(Col1) &gt; date '"&amp; TEXT( Today() , "yyyy-MM-dd" ) &amp; "' And toDate(Col1 ) &lt;= date '"&amp; TEXT( EOMONTH( Today() , 1) , "yyyy-MM-dd" ) &amp; "' "))
</code></pre>