Group By DateValue fails in Access 2K

[J]

In Access 2000 the following query works:

Select DateValue(EnteredTime)
From tblMyTable

But adding the following clause fails:

Group by DateValue(EnteredTime)

The error is:

Data type mismatch in criteria expression. A similar query appears to work
ok in Access 2003.

Thx for your help.

[Steve Jorgensen]

On Mon, 26 Jul 2004 00:03:31 -0500, "J" <so*********@nobody.com> wrote:

In Access 2000 the following query works:

Select DateValue(EnteredTime)
From tblMyTable

But adding the following clause fails:

Group by DateValue(EnteredTime)

The error is:

Data type mismatch in criteria expression. A similar query appears to work
ok in Access 2003.

Thx for your help.

What is DateValue? Do you mean CDate?

[J]

What is DateValue? Do you mean CDate?

It's an Access function that's apparently commonly used in order to retrieve
the date only from a datetime field.

[Steve Jorgensen]

On Mon, 26 Jul 2004 10:52:42 -0500, "J" <so*********@nobody.com> wrote:

What is DateValue? Do you mean CDate?

It's an Access function that's apparently commonly used in order to retrieve
the date only from a datetime field.

I guess I've never known about that. I've always used
CDate(Int(<datevalue>)). Perhaps, that will work in your case, if DateValue
will not.