how to make difference between two months format mm/yyyy

prasanna p

Dear Friends,

I have one task, When product expiry date is reached alert should come before one month like"your product is expired after 30 days".

I am storing expiry date in the format "mm/yyyyy".

how to acheive this task without dd part?

Please suggest me.

Regards

Prasanna.

4 Replies

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

Munesh Sharma10y ago
List result = new List();

DateTime startDate = new DateTime(2012, 1, 8);

DateTime endDate = new DateTime(2013, 1, 3);

DateTime temp = startDate;

endDate = new DateTime (endDate.Year, endDate.Month, DateTime.DaysInMonth(endDate.Year,endDate.Month));

while (temp <= endDate)

{

Console.WriteLine((string.Format("{0}/{1}", temp.Month, temp.Year));

temp = temp.AddMonth(1);

}
Rajeesh Menoth10y ago
Hi,

Do you need a fixed format then use the following code.

Mention your date format in the following code (MM/yyyy ) and Use capital "MM" in your format it display the month otherwise "mm" one is display minute.When you pass any date in date object it will display like this "5/1/2016 12:00:00 AM".So we can format this date using "String.Format"
in C#.

Code :
using System;
using System.Globalization;

public class Program
{

    public static void Main()
    {
        string date1 ="05/2016";
        DateTime From = DateTime.ParseExact(date1, "MM/yyyy", CultureInfo.InvariantCulture);
        Console.WriteLine(string.Format("{0:MM/yyyy}",From) );

    }
}
CultureInfo :
It's Provides information about a specific culture.The information includes the names for the culture, the writing system, the calendar used, the sort order of strings, and formatting for dates and numbers.

Reference :

http://www.c-sharpcorner.com/code/1459/string-was-not-recognized-as-a-valid-datetime.aspx

Demo : https://dotnetfiddle.net/UHlRor

The answer is useful.Then please accept it..!!
ali tuncer10y ago
since you don't have dd part , when you compare dates, you can assume it is 01 by default...
Manas Mohapatra10y ago
Add below code to DateTime object:
string myDate = "05/2016"; // May 2016
DateTime myDateObj = DateTime.ParseExact(myDate, "MM/yyyy", CultureInfo.InvariantCulture); //5/1/2016
After conversion you will get 1st May 2016 as result. Next, you can implement your own logic to display alert...