Here's the solution: you have to convert and format every occurrence of the
dates or they revert to simple strings, so the query that works reads as
follows:
SELECT
TO_DATE(T.DATEENROLCONFIRMED, 'ddmmyyyy') EnrollDate
FROM
Servername.tblinvoicedetails T
WHERE
TO_DATE(T.DATEENROLCONFIRMED, 'ddmmyyyy') < TO_DATE('05102003', 'ddmmyyyy'>
ORDER BY TO_DATE(T.DATEENROLCONFIRMED, 'ddmmyyyy')
Seems very clumsy but I guess it puts all the control in the hands of the
programmer. Makes me appreciate my normal environment of MS SQLServer
however.
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX 6.1, now 2.5 times faster.
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1752
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
