title: How can I schedule bi-weekly jobs?
body: <p>My app requires users to schedule recurring events that can recur daily, weekly, monthly, or bi-weekly.</p>
  
  <p>By bi-weekly, I mean every fortnight (14 days) starting from an arbitrary date value provided at the time of creation.</p>
  
  <p>My <code>jobs</code> table has two columns to support this: <code>job_frequency_id</code> and <code>job_frequency_value</code>. I'm able to schedule all types except for bi-weekly.</p>
  
  <p>The first col is an FK to the <code>job_frequencies</code> table; it contains <code>daily, weekly, monthy, bi-weekly</code> values. The <code>job_frequency_value</code> contains the value corresponding to the frequency.</p>
  
  <p>For example: If a job has a <code>job_frquency_id == 3</code> and <code>job_frequency_value == 10</code>, it will run every 10th day of the month.</p>
  
  <p>How do I add bi-weekly support without tampering with my db structure? I will use the <code>job_frequency_value</code> col to store the start date of the 14 day period, but I'm unsure of the calculation going forward.</p>