How to find 42 days as 1 month 1 week 5 days in ASP.Net c#

Question

0.00/5 (No votes)

See more:

Hi, I have the difference between two dates as 42 days, I want a program for apply penalty value on it, first as monthwise(it is 3), weekwise(it is 2), daywise(it is 1) respectively. What is C# code for this?

Posted 23-Jan-14 23:34pm

SVT02

Updated 23-Jan-14 23:53pm

Vladimir Svyatski

v2

Add a Solution

Comments

Vladimir Svyatski 24-Jan-14 5:55am

It heavily depends on a month. Each month has different number of days, you know.

3 solutions

Solution 2

I don't think it is possible or logical.you can't use datetime in the code or you can't say i need a report of February 31st.you have to define yourself.you can create a table to do this.
say you have a table with this fields monthName, dates etc.

Posted 27-Jan-14 18:41pm

Ahmed Jubayer

Solution 3

I would start with an array of all the months with the number of days they have in them. This would allow you to work around what has been stated above.

The biggest questions I would start with to work around. Is one month 28, 29, 30, or 31 days or does one month mean exactly the same date next month < ambiguous I know but let me show you. In a normal month lets say Jan. there might be 31 days. A month from the 2nd of January would be the 2nd of February. The above array would work through that. The biggest problem you are going to run into is that today is the 29th. 1 month from today is what? the 29th of February so does it become the 28th of February or the 1st of March.

Using the above array and resolving the issue of a month from now not really existing, or saying a month from now is the number of days equal to the current month, therefore a month from the 31st of January would be the 3rd of March (31 days since Jan. has 31 days). Anyway there are several ways to solve that. After that is solved its pretty trivial algebra.

Posted 29-Jan-14 3:32am

Tdmonkeypoop

Updated 29-Jan-14 3:34am

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)

OriginalGriff · Accepted Answer · 2014-01-23T23:45:00

It's not that simple: the "difference" between to dates is a timespan - which is not related to any particular day of the year, and so can't be expressed as a "months", "weeks" and "days" count - the numbers you would get would vary considerably if the start date was February 27th to those you would get for March 27th for example.
What you want is a timespan that is relative to a particular date - an Age: Working with Age: it's not the same as a TimeSpan![^]