Hi Nathan..
It worked..! :) thanks again :)
Regards,
Ravi
On Fri, Jul 3, 2009 at 12:01 AM, Ravindra Harige
wrote:
> Thanks Nathan for the quick reply. will try this and report back.. :)
> Regards,
> Ravi
>
>
> On Thu, Jul 2, 2009 at 11:51 PM, Nathan Sullivan wrote:
>
>
p, interval 2 day))) then 3
> else 4
> end, date_field_3, date_field_2, date_field_1;
>
> -Original Message-
> From: Nathan Sullivan
> Sent: Thursday, July 02, 2009 1:07 PM
> To: 'Ravindra Harige'; mysql@lists.mysql.com
> Subject: RE: Adhoc sorting requirement
&
Hi,
I have a very ad hoc sorting requirement and would like to know how this can
be achieved.
The requirement is as follows:
I have a table (of say 100 records) with 3 DATE fields:
date_field_1 , date_field_2 , date_field_3
I have a date range, for eg. from (today) to (today+2) and
Each one of th
