SELECT Date, #DateDiff(date, now())# AS "DateSpan"
FROM Dates
ORDER BY DateSpan
chris
----------------------------------------------
Original Message
From: "David Shadovitz"<[EMAIL PROTECTED]>
Subject: Re: SQL ORDER BY Problem
Date: Tue, 5 Sep 2000 06:18:33 -0700
>Wouldn't your results be the same if you just ordered by Date? You're
>merely (trying to) subtract a constant from each Date.
>-David
>
>On Tue, 5 Sep 2000 "James Smith" <[EMAIL PROTECTED]> writes:
>> I have a query that selects dates from a datasource, and I would like
>> to
>> order by the number of days to the next occurrence, but the
>> following
>> doesn't work.
>>
>> SELECT Date
>> FROM Dates
>> ORDER BY #DateDiff(date, now())#
>________________________________________________________________
>YOU'RE PAYING TOO MUCH FOR THE INTERNET!
>Juno now offers FREE Internet Access!
>Try it today - there's no risk! For your FREE software, visit:
>http://dl.www.juno.com/get/tagj.
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.