Compare Datetime from sql

Question

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.

Suthish Nair · Answer

A single line of code is enough? Response.Write( DateTime.Today.Subtract(DateTime.Parse(01-Mar-2011)).Days );

Mohammad Imran · Answer

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 Nair · Answer

Your way is also good i just shown to reduce number of code lines (kind of optimization). Happy coding :)

Vulpes · Answer

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 Nair · Answer

Like this also.. int i = DateTime.Today.Subtract(DateTime.Parse(01-Mar-2011)).Days;\ String message = (i >= 0 && i

Vulpes · Answer

Well I suppose he could do: Messagebox.Show(((DateTime.Today - DateTime.Parse(string_date)).Days >= 0 && (DateTime.Today - DateTime.Parse(string_date)).Days but it's hardly clear and it's also inefficient because the same TimeSpan has to be worked out twice.

Mohammad Imran · Answer

Thanks Vulpes. its exactly wat i want. Thankyou

Vulpes · Answer

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 { message = Yes; } else { message = No; } MessageBox.Show(message);