Bigquery SQL semi monthly date range
<p>I have a report that has a query that needs to automated so that the data range returned is semi monthly (1 - 15) (16 - end of month)  </p>

<p>So, if the report is run on the 1st of the month, the date range is for the prior months 16th - end of prior month.  </p>

<p>If the report is run on the 15th, the range is for the current month 1st - 15th.</p>

<p>I am planning to use a between. but I need to be able to dynamically generate the dates for the date_from and date_to range.</p>

<p>Is somthing like this possible (perhaps using current date and some calculation)?</p>

<p>Help is greatly appreciated.</p>

<p>Eric</p>