<div>
Are you talking about a database field, or a class field? &nbsp;What version of .NET are you using? &nbsp;Do you have any knowledge about LINQ?
</div>


Are you talking about a database field, or a class field?  What version of .NET are you using?  Do you have any knowledge about LINQ?

<div>
Where are the dates stored?
</div>


<div>
Hi,<br />
<br />
It's a database field, .NET 3.5<br />
I'm using SQL Statement with Store Procedure.<br />
Thanks, sorry I'm new with ASP.NET, please bear with me.
</div>


Hi,

It's a database field, .NET 3.5
I'm using SQL Statement with Store Procedure.
Thanks, sorry I'm new with ASP.NET, please bear with me.

<div>
You can get the correct value from a SQL statement like this:<br />
<br />
select max(YourDateColumn) from YourTable<br />
<br />
I hope this helps.
</div>


You can get the correct value from a SQL statement like this:

select max(YourDateColumn) from YourTable

I hope this helps.

<div>
If you have a fixed number of fields, then you might be able to use a CASE statement in the query, but MAX only returns the maximum for a single column, not the max between different fields in the same row.
</div>


If you have a fixed number of fields, then you might be able to use a CASE statement in the query, but MAX only returns the maximum for a single column, not the max between different fields in the same row.

<div>
SELECT MAX works as an SQL statement. Thanks,<br />
How do I start with the C# Code?<br />
And yes, it's a single column only for now.<br />
Thank you.
</div>


SELECT MAX works as an SQL statement. Thanks,
How do I start with the C# Code?
And yes, it's a single column only for now.
Thank you.

<div>
<div class="content wysiwyg-content">
I need to getLatestDate from certain field with some records.<br />
Using C#, How do I compare all those dates in the records?<br />
Let's say I have this table:<br />
<br />
Test1: 5/20/2010<br />
Test2: 8/12/2010<br />
Test3: 2/1/2011<br />
Test4: 11/2/2010<br />
<br />
I want the code to return 2/1/2011 from Test3<br />
<br />
Thanks,<br />
<br />
Danny
</div>
</div>


I need to getLatestDate from certain field with some records.
Using C#, How do I compare all those dates in the records?
Let's say I have this table:

Test1: 5/20/2010
Test2: 8/12/2010
Test3: 2/1/2011
Test4: 11/2/2010

I want the code to return 2/1/2011 from Test3

Thanks,

Danny

How do I get latest(max) date from the field?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).