<div>
CASE WHEN datefield=getdate() THEN ... <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHEN datefield&gt;getdate() THEN ...<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ELSE ... <br />
END
</div>


CASE WHEN datefield=getdate() THEN ...
          WHEN datefield>getdate() THEN ...
          ELSE ...
END

<div>
I'll give that a try guys. Just so you know, the <br />
<br />
urDateColum is already in a datefield, don't know if that makes a difference or not... does it?
</div>


I'll give that a try guys. Just so you know, the

urDateColum is already in a datefield, don't know if that makes a difference or not... does it?

<div>
<div class="content wysiwyg-content">
Hey all, i'm trying to compare a date that is in a field in the database to todays date.<br />
<br />
So if dateField=getdate() then... &nbsp;how do i do this?<br />
<br />
if 2/5/2008=2/5/2008 then.... <br />
<br />
Is there anyway that i can also make it conditional? If there is no match for today, then do a anything &lt;&nbsp;today? thanx all
</div>
</div>


Hey all, i'm trying to compare a date that is in a field in the database to todays date.

So if dateField=getdate() then...  how do i do this?

if 2/5/2008=2/5/2008 then.... 

Is there anyway that i can also make it conditional? If there is no match for today, then do a anything < today? thanx all

MS Sql Help, comparing dates

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.