Re: Query DateTime Field
From: Tausif (mtalam_at_hotmail.com)
Date: 05/31/04
- Next message: Tausif: "Re: Query DateTime Field"
- Previous message: Tausif: "Re: Query DateTime Field"
- In reply to: Tausif: "Query DateTime Field"
- Next in thread: Tausif: "Re: Query DateTime Field"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 May 2004 12:23:05 +0800
I checked it is due to some records having NULL in the datestamp field .
Now, In this case; how can i use datevalue function.
regards,
Tausif.
"Tausif" <mtalam@hotmail.com> wrote in message
news:ev4IHDsREHA.2468@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have a field DateStamp, stores both date and time. I would like put a
> query with which I can only compare date but not the time. I put this
query
> but it is not working. Please help thankx..
>
> SELECT transactions.ChangeRequest FROM transactions WHERE 1=1 AND
> transactions.[Date Request] = #5/31/2004# ORDER BY transactions.Status
>
> Thankx
>
>
- Next message: Tausif: "Re: Query DateTime Field"
- Previous message: Tausif: "Re: Query DateTime Field"
- In reply to: Tausif: "Query DateTime Field"
- Next in thread: Tausif: "Re: Query DateTime Field"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
