I believe the top suggestion, to find just one record using MAX should do the job. It is possible that the table has multiple records with the same date. But I simply need to find the most recent date, no matter what record.
Thank you!
>SELECT MAX( cast( DateTimeField as Date)) from MyTable
>
>Now...if you want to find all the rows (i.e. transactions) that have that same date as the max date
>
>SELECT * from MyTransactions
>where cast( DateTimeField as date) = (SELECT MAX( cast( DateTimeField as Date)) from MyTransactions)
>
>
>
>>Hi,
>>
>>I am working on creating a SQL Select (against a SQL Server) to find a record with the most recent DATETIME field. But I am only concerned with the DATE portion of this DATETIME field (since the time is irrelevant). Here is a small pseudo example:
>>
>>select Date_Time from MyTable where Date_Time_Is_Most_Recent
>>
>>
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
