Find Max Date With Time Stamp

[Guest]

I need a query that will find the latest date or time. I have used the MAX
query, but that is not working.

Here's what I have.

9/15/2004 10:29:10 AM
9/15/2004 12:08:41 PM
9/15/2004 4:01:05 PM

I need the date from the line 9/15/2004 4:01:05 PM. I have tried to parse
this out with DateValue and TimeValue, but it still isn't working.

Thoughts?

 

[Brendan Reynolds]

Max should work if this were a Date/Time field, so I'm guessing its a Text
field. In that case, something like this should work ...

SELECT Max(CDate([TestText])) AS MaxDate
FROM tblTest2;

 

[Guest]

Actually, this is categorized as a "Date/Time" field on the table.

Other ideas?

Max should work if this were a Date/Time field, so I'm guessing its a Text
field. In that case, something like this should work ...

SELECT Max(CDate([TestText])) AS MaxDate
FROM tblTest2;

--
Brendan Reynolds
Access MVP

I need a query that will find the latest date or time. I have used the MAX
query, but that is not working.

Here's what I have.

9/15/2004 10:29:10 AM
9/15/2004 12:08:41 PM
9/15/2004 4:01:05 PM

I need the date from the line 9/15/2004 4:01:05 PM. I have tried to parse
this out with DateValue and TimeValue, but it still isn't working.

Thoughts?

 

[Guest]

Post the entire SQL statement. If it is a Date/Time field, something else is
going on.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Actually, this is categorized as a "Date/Time" field on the table.

Other ideas?

Max should work if this were a Date/Time field, so I'm guessing its a Text
field. In that case, something like this should work ...

SELECT Max(CDate([TestText])) AS MaxDate
FROM tblTest2;

--
Brendan Reynolds
Access MVP

I need a query that will find the latest date or time. I have used the MAX
query, but that is not working.

Here's what I have.

9/15/2004 10:29:10 AM
9/15/2004 12:08:41 PM
9/15/2004 4:01:05 PM

I need the date from the line 9/15/2004 4:01:05 PM. I have tried to parse
this out with DateValue and TimeValue, but it still isn't working.

Thoughts?