How to Compare Two dates with Previous/Old Two dates

Question

I've to compare Start Date and End Date with the previous entry of Date duration in database, Actually i want to perform advance salary, I calculated No of Months between start date and end date and created the salary for calculated months in advance, now i want to make it sure that if i create the salary and months lies inside the advance salary created then show a validation error msg that Advance Salary Paid for this duration. Thanks in advance.

Rameez Javed · Answer

Thanks Rabiranjan Singh ! I don't think so it will compare with datadase previous entry of date duration, think about salary in advance and validation error on creation of same month salary that lies in previous advance salary...

Rabiranjan Singh · Answer

Hi Rameez Javed You can compare two date simply as below if your date is DateTime type. DateTime dt1 = DateTime.ParseExact("06-01-1995", "dd-MM-yyyy", null); DateTime dt2 = DateTime.ParseExact("18-10-2018", "dd-MM-yyyy", null); int cmp = dt1.CompareTo(dt2); if (cmp > 0) { // date1 is greater means date1 is comes after date2 Console.WriteLine("date1 is greater means date1 is comes after date2"); } else if (cmp { // date2 is greater means date1 is comes after date1 Console.WriteLine("date2 is greater means date1 is comes after date1"); } else { // date1 is same as date2 Console.WriteLine("date1 is same as date2"); } output date2 is greater means date1 is comes after date1 . if you have still problem then feel free to comment