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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.