Querying a Date/Time field on DATE only (1 Viewer)

L

Lyconal

Registered User.
Local time
Yesterday, 20:31
Joined
May 18, 2009
Messages
35
Hi,

Anybody know how to do this?

I have tried converting the date on the fly, but to no avail.

Any help is appreciated.

Cheers
 
Brianwarnock

Brianwarnock

Retired
Local time
Today, 04:31
Joined
Jun 2, 2003
Messages
12,701
Datevalue will extract the date from a date/time field

Brian
 
L

Lyconal

Registered User.
Local time
Yesterday, 20:31
Joined
May 18, 2009
Messages
35
Cheers for that.

Was pulling my hair out trying to use CONVERT (like I would normally in SQL2000)

Cheers very much :)
 
Brianwarnock

Brianwarnock

Retired
Local time
Today, 04:31
Joined
Jun 2, 2003
Messages
12,701
Happy to help, not confused by too much knowledge!:D

Brian
 
You must log in or register to reply here.

Similar threads

J
Show Data for this week only
Replies
4
Views
129
cheekybuddha
cheekybuddha
T
Date Filter: Between Yesterday and 365 days
Replies
6
Views
314
Pat Hartman
P
MattBaldry
Query Error in List Box
Replies
2
Views
107
MattBaldry
MattBaldry
G
EXACT NUMBER OF HOURS BETWEEN TWO DATES AND TIME
Replies
13
Views
556
The_Doc_Man
The_Doc_Man
M
Report from Parameter Query
Replies
1
Views
328
arnelgp
arnelgp

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom