Compare Datetime from sql

Mohammad Imran

Hello,
I want to find the difference between two dates. one is current date and second one is date which is stored in sql database.

like i have to compare a string from current date and if string_date is less than 15 days from current date then i have to send a message yes or no.

Please help me its urgent.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted answer
A single line of code is enough?

Response.Write(DateTime.Today.Subtract(DateTime.Parse("01-Mar-2011")).Days);
Mohammad Imran15y ago
Thank you Suthish Nair for ur help....... i will use your code line in my another projects but this time the answer given by Vulpes is exactly what i needed so i used that.

Thank you all.
Suthish Nair15y ago
Your way is also good, i just shown to reduce number of code lines (kind of optimization). Happy coding :)
Vulpes15y ago
Yeah, two lines is OK and is probably how I'd do it myself in practice - I'm quite keen on the ternary operator :)
Suthish Nair15y ago
Like this also..

int i = DateTime.Today.Subtract(DateTime.Parse("01-Mar-2011")).Days;\

String message = (i >= 0 && i < 15) ? "Yes" : "No"
Vulpes15y ago
Well, I suppose he could do:

Messagebox.Show(((DateTime.Today - DateTime.Parse(string_date)).Days >= 0 && (DateTime.Today - DateTime.Parse(string_date)).Days < 15)) ? "Yes" : "No");

but it's hardly clear and it's also inefficient because the same TimeSpan has to be worked out twice.
Mohammad Imran15y ago
Thanks Vulpes. its exactly wat i want. Thankyou
Vulpes15y ago
Well, assuming you've already retrieved string_date from the database and it's a pure date (i.e. no time component) in string form, then the code to do that would be something like this:

DateTime dt = DateTime.Parse(string_date);
TimeSpan ts = DateTime.Now.Date - dt;
string message;
if (ts.Days >= 0 && ts.Days < 15)
{
message = "Yes";
}
else
{
message = "No";
}
MessageBox.Show(message);