doubt in sql server -datetime comparison

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi to all,

currently i am doing project in tender mgmt.
if i want to insert the tender details,i want tender announced date and due date. i entered the tender announced date as 5/12/2010 and due date as 5/6/2009. it is not acceptable,bcoz due date must be above the announced date, i want to do date comparison .pls tell me

Posted 23-Mar-11 21:15pm

dhanyasri

Add a Solution

3 solutions

Solution 1

You can always use DateDiff to do a date comparision.[^]

Posted 23-Mar-11 21:21pm

Abhinav S

Solution 2

Use JavaScript[^] before inserting into database or

Use Compare validator[^].

Posted 23-Mar-11 21:22pm

Toniyo Jackson

Updated 23-Mar-11 21:23pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahendra.p25 · Accepted Answer · 2011-03-23T21:27:00

Use Compare Validator if you are using asp.net

XML

<asp:CompareValidator ID="cmvdate" Display="Dynamic" ErrorMessage="InvalidDate" SetFocusOnError="true"
                                        runat="server" ControlToCompare="txt_DateFrom" ControlToValidate="txt_DateTo"
                                        Operator="GreaterThanEqual">*</asp:CompareValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidator1" ControlToValidate="txt_DateTo"
                                        SetFocusOnError="true" Display="Dynamic" ValidationExpression="(([1-9]|1[012])[- /.]([1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d)|((1[012]|0[1-9])(3[01]|2\d|1\d|0[1-9])(19|20)\d\d)|((1[012]|0[1-9])[- /.](3[01]|2\d|1\d|0[1-9])[- /.](19|20)\d\d)"   ErrorMessage="Date" runat="server">*

if You want that in Sql Server
Check
declare @StartDate datetime, @EndDate datetime

if(@StartDate<@EndDate datetime)
begin
Your Code
end
else
Your Code
begin
end