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 <f_ap@lycos.nl>:
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
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss