title: How to create date based on year, week number and day in bigquery
body: <p>How to form date from the year, week number and day value in Bigquery query.</p>
  
  <p><strong>For example-</strong> Year =2019, week number =37 day=Wednesday. </p>
  
  <p><strong>Output:</strong> <em>(2019-09-18)</em></p>
  
  <p>Year =2019, week number =36 day=Tuesday. </p>
  
  <p><strong>Output:</strong> <em>(2019-09-10)</em></p>
  
  <p>Here month will be calculated from the week and date will be based on when the given day falls in that week.</p>
  
  <p><strong>Note:</strong> Bigquery starts a week from 0, so if check above value for comparison in another system it could be 38 and 37</p>