title: Add 48 hours to a date to create a new date, add 48 hours to new date and repeat until end date is reached
body: <p>I have 3 datetime stamps: Date of Admission, Date of Discharge, Date of Review.</p>
  <p>There is only 1 admission date and 1 discharge date per patient but multiple Review dates in between the admission and discharge dates.</p>
  <p>I am being asked to report whether or not a review was completed every 2 days from admission to discharge. There is a timestamp captured each time a review is completed and its stored in the Review Date column.</p>
  <p>I understand that I can use the <code>dateadd</code> function to add 48 hours to the admit date but then I need to add 48 hours to that new date and keep doing this until discharge in order to capture each possible 48 hour interval in which a review should have been completed and I don't know how to do that.</p>
  <p>I would then use the newly created timestamps of 48 hours intervals from admission, in order to see if a review was completed between each 48 hour interval from admit to discharge.</p>
  <p>This is an example of what I have currently:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">PATIENT_VISIT_ID</th>
  <th style="text-align: center;">ADMIT_DATE</th>
  <th style="text-align: center;">DISCHARGE_DATE</th>
  <th style="text-align: center;">REVIEW_DATE</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/5/2021 11:51</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/5/2021 11:51</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/9/2021 16:18</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/9/2021 16:19</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/9/2021 16:20</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/10/2021 10:38</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/11/2021 11:30</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/13/2021 15:30</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/13/2021 15:32</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/13/2021 15:33</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/15/2021 13:14</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is what I am trying to do:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">PATIENT_VISIT_ID</th>
  <th style="text-align: center;">ADMIT_DATE</th>
  <th style="text-align: center;">DISCHARGE_DATE</th>
  <th style="text-align: center;">48 Hour Intervals from admit</th>
  <th style="text-align: center;">Review completed within this particular 48 hour interval?</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/2/2021 11:53</td>
  <td style="text-align: center;">No</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/4/2021 11:53</td>
  <td style="text-align: center;">No</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/6/2021 11:53</td>
  <td style="text-align: center;">Yes</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/8/2021 11:53</td>
  <td style="text-align: center;">No</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/10/2021 11:53</td>
  <td style="text-align: center;">Yes</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/12/2021 11:53</td>
  <td style="text-align: center;">Yes</td>
  </tr>
  <tr>
  <td style="text-align: center;">123</td>
  <td style="text-align: center;">3/31/2021 11:53</td>
  <td style="text-align: center;">4/15/2021 16:23</td>
  <td style="text-align: center;">4/14/2021 11:53</td>
  <td style="text-align: center;">Yes</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Hope this makes sense. Any help would be very much appreciated.</p>