Hi James, I reckon your method is the winner for your described searching.
It's a cleaner way to store the dates, as you are storing specific datepart values, and more readable when sifting through the data. It would only be slightly more involved to conduct SQL searches spanning a date range like 10/03 - 09/04, but it doesn't sound like your app needs that. Storing the number of days different from a base date would make it simpler to SQL search ranges (DaysDiff > -35398 and DaysDiff < -32144), but not a given day and month for every year. Cheers, Ben "James Silva" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My app gives the user the option of selecting: > > a day + a month + a year OR > a day + a month + ALL years > (to get re-occuring events for a given day/month). --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
