Dear all,
I want to get the greatest date (in datetime format) from a table.
when I try,
<%
....
rs.open "select max(cr_dt) as ma from prospect",cn
response.write(rs(0))
...
%>
The output is 7/4/2001 10:21:27 AM.
But I have another value 7/4/2001 1:53:10 PM, which is greater than the output value.
I guess the max() function isnt working properly with the datetime field.
How should I get the greater datetime from my table
Cheers and thanx in advance
Parasuraman
