> 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:313204
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
