RE: storing recurring dates

2005-06-12 Thread mfatene
hi, have you tried to hack something with week, month and weekofyear ? there is an interesting url at http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html be aware that the week begins on sunday. mysql> select weekofyear('2005-01-02'); +--+ | weekofyear('2005-01-0

RE: storing recurring dates

2005-06-12 Thread christopher . l . hood
Bob, You should check out the Date::Manip module from CPAN, it will do what you need to do. Here is a snippet from the docs about recurrence: RECURRENCE A recurrence is simply a notation for defining when a recurring event occurs. For example, if an event occurs every other Friday or every 4