Re: [SQLObject] Distinct value lookup on DateTimeCol()

[TiNo <ti...@gm...>]

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_...@ly...>:
>
> 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
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>