> S. Isaac Dealey wrote: >> There's also DateFormat(mydate,"d") which returns the >> same value, but >> DayOfMonth() makes a lot more sense when you're reading >> someone else's code.
> There is also an SQL standard EXTRACT function, that will > work in other > SQL compliant databases. Unless of course you prefer to > have these > problems every time you change databases. > Jochem Yep, that probably makes a lot more sense. :) I sort of glazed over the thread actually... I should probably reserve participation for when I have time to actually read the thread. ;) s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com