Why not use the built in database "date_format" function to format your date? Probably be a lot easier, and there shouldn't be any translation problems because it's working with a native format.
andy -----Original Message----- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2008 8:33 AM To: cf-talk Subject: Re: what sorta date? > I have a date being returned to me. It's not a normal date as I'm > used to seeing them. > Wed, 24 Sep 2008 13:32:00 +0000 > > When I do a dateformat() on it, it works fine. When I do a db call, > it doesn't though (it works very oddly). Should I break it down by > years, month, day and do a createdate on it? I forgot to mention, that date listed above is the one in the database (pubdate) and I don't have any control over the database information. I'm trying to find records are higher than my start_archives_date. Here's my query: <cfset start_archives_date = createDate(2008,9,1)> <cfquery name="archives" dbtype="query"> SELECT pubdate FROM featuresQuery WHERE pubdate >= #start_archives_date# </cfquery> Sorry for the incomplete previous posting. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
