Hi TiNo,
To comment on your solution. #tested. Your approach results in all months between the two dates given and not between the month given of each individual year between the dates given. With best regards, Frans.TiNo wrote: > Howabout: > > yearstart = 1000 > yearend = 3000 > (or if you really want it time-independant: yearstart = date.today()[0] > - 200, yearend = yearstart + 400 oid) > monthstart = montend = june > daystart = 1 > dayend = 31 > > ?? > > Next week is a little more complicated, but you can do the it the same > way, you just have to find the dates for what you call 'next week'... > > TiNo > > 2007/6/18, F.A. Pinkse <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>: > > Hi, > > Oeps, I did hit the send button to soon and forgot to add this. > > So the year part is solved but now what can I do when I want to > construct a monthly birthday calender. > As in who celebrates his birthday in the month of june? > Or who do I send a postcard for their birthday next week? > > Setting a start and end date in the select? > How would one do that with a DateTimeCol()? > > With best regards, > > > Frans. > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > sqlobject-discuss mailing list > sqlobject-discuss@lists.sourceforge.net > <mailto:sqlobject-discuss@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > sqlobject-discuss mailing list > sqlobject-discuss@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
