> daniel kessler wrote:
> > 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
>
> What is abnormal about that date? It seems like a normal format.
> Do a ParseDateTime with the pop option to cast the string to a date
> object.
>
So if I understand correctly, I'm supposed to do that not on the db date, but
on the date I'm using to compare.
I've come up with something but I'm getting an error on it ("{ts '2008-09-01
01:01:01'}" is not a valid date format).
<cfset start_archives_date = createDateTime(2008,9,1,1,1,1)>
<cfquery name="archives" dbtype="query">
SELECT pubdate
FROM featuresQuery
WHERE pubdate >= #ParseDateTime(start_archives_date,'pop')#
</cfquery>
<sigh>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:313214
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
