I had the following fields for my calendar: start_date = "08/01/09" (starts on) end_date = "08/31/09" (ends on) the_length = "1" (everyday) repeat_every = "2" (with an interval of 2 days)
Now, I want to use SQL statement to populate "daily" but with an interval of "2" days, starting from "start_date" up to "end_date". I was able to solve the problem on the application side, but I want to hit it using SQL Statement. And I was able to solved the problem without using the "repeat_every" field.
