Re: Date query .... please help!
From: Ramesh <mesh7_at_tm.net.my>
Date: Sat, 6 Apr 2002 20:01:20 +0800
Message-ID: <3caee2ce$1_1_at_news.tm.net.my>
Date: Sat, 6 Apr 2002 20:01:20 +0800
Message-ID: <3caee2ce$1_1_at_news.tm.net.my>
Hi Shamil,
Thanks for the input, Yes there is a misprint on the query. I have tried your method, it still does not work for 2 time frame within a day but it works for 2 time frame of different dates.
Thanks again.
"Shamil Valeev" <valeevsh_at_mail.ru> wrote in message
news:a8midc$c99$1_at_news.nsk.su...
> Hi Ramesh,
>
> I am not sure this query works at all since you select a field MCNO and
try
> to group by a field TEAM.
> I think this is just a misprint.
>
> Returning to your question I would suggest using mask YYYY instead of YY
> and HH24 instead of HH.
>
>
>
>
Received on Sat Apr 06 2002 - 14:01:20 CEST