Frank,
You are correct. I replaced the default SQL Server driver with the SQL Server Native Client 11 and the type of the query field is a Date type.
Thanks, again.
>Hi Dmitry,
>my guess is that you are using an old ODBC driver that does not know the Date type.
>
>>Just a follow-up question.
>>Why does the field DATE (in the SQL Select you suggested) is a Char type? Nothing wrong. I would just like to understand why when you CAST the DateTime to DATE, the result is a char type and not a Date type.
>>
>>>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