Calculate ageing in ASP.NET from the date of submission

Question

0.00/5 (No votes)

See more:

Hello,

I am developing a project and for that i need to calculate the 'Ageing'. The Ageing will be displayed in another page and should keep on increasing with each passing day.
The Ageing will be calculated as (The date when the form is submitted - Today's Date).And when the form is submitted the Ageing also gets saved in SQL database.
What i have done so far is on the Submit button click event i have stored the date of form submission in a variable 'Now'. And to calculate the Ageing i have subtracted Today's Date from it.
Below is my code

C#

string Ageing = (DateTime.Today.Subtract(Convert.ToDateTime(now)).TotalDays).ToString();

But the problem is it does not increment with each day. Like if a user submits a case today i-e (5-Oct-2016) and initially the ageing should be 0, because the date form is submitted and current date is the same so after subtracting them it should be 0. But when a User comes tomorrow i-e (6-Oct-2016) and check the ageing it should be 1 and should keep on increasing with each passing day automatically.
Please help, your help would be highly appreciated.

What I have tried:

I have tried using the above mentioned code but whenever user submits the form. It stores the ageing as 0 and it never gets incremented.
I want it to getting increased by each passing day.
Like if the case was submitted on 2-Oct-2016 and today is 5-Oct-2016 so it should show Ageing as 3. (Since (5-Oct-2016) - (2-Oct-2016) = 3)

Posted 5-Oct-16 7:15am

Faran Saleem

Updated 11-Oct-16 2:04am

v2

Add a Solution

Comments

[no name] 5-Oct-16 13:45pm

It's really hard for me to imagine what it is that you are doing since we can't see the code but it actually sounds like on you form submission you are setting the variable "now" to the current date and then subtracting that from the current date....? And expecting something other than 0. Is that about right?

Faran Saleem 5-Oct-16 13:58pm

No, I think i did not explain correctly.
What i am trying to do is calculate Ageing on the basis of the date when the form was submitted minus the current date.
Now lets assume the form was submitted on 2nd Oct 2016, so when the User submits the form on 2nd Oct 2016, he/she should view ageing as 0 because the form submission date and the current date is same so the result is 0.
But when the user visits the page the next day i-e on 3rd Oct 2016 and he/she sees the submitted forms then the ageing should be 1, because the form was submitted on 2nd Oct 2016 and the user is seeing the form on 3rd oct2016, so the difference is 1 day and Ageing in this case should be 1. And similarly when the user views the form on 4th Oct 2016 the Ageing should be 2, and likewise for 5th Oct 2016 the ageing should be 3, because the form was submitted on 2nd oct 2016 and current date is 5th Oct 2016 so it should calculate the difference between the two dates.
I hope i have cleared your confusion, if there is still any query please ask

[no name] 5-Oct-16 14:06pm

Yes I get that. What you want to do and what you are doing are two different things. Where are storing this submission date so you can retrieve it at a later time to do your ageing calculation?

Faran Saleem 5-Oct-16 14:07pm

I am storing it in SQL Database.

[no name] 5-Oct-16 14:11pm

Well then it should be pretty easy for you to debug your code and find out where it's going wrong. We are not going to be able to tell you anything from one line of code why your code it not behaving like you expect it to.

Faran Saleem 5-Oct-16 14:18pm

I have figured out why it is not behaving as the way it should be, the reason is because the ageing on the basis of current date and the form submission date is getting calculated on the button submit event. So whenever the user hits the submit button the Ageing is calculated as 0 because at that moment the current date and form submitted date is same. But it will never get incremented, user will see ageing as 0 even if he visits the page after 10 days as ageing is getting calculated only when the button submit is pressed.
I am unable to create a logic where a user submits the form and the ageing will get increased with each passing day.
That is why i need help.

[no name] 5-Oct-16 14:20pm

Okay.... I am not sure why that is a problem.... Save the date to your database ONCE. Get the date from the database when you need to calculate the ageing.

[no name] 5-Oct-16 14:15pm

Your narrative says that you are storing the current date in your database every time the the form is submitted. If that is true, there is your problem.

Faran Saleem 5-Oct-16 14:28pm

Yes that is exactly what is happening.. how can i solve this? can you please guide?

[no name] 5-Oct-16 14:37pm

Save the date to your database ONCE. Get the date from the database when you need to calculate the ageing.

5 solutions

Solution 2

This may help: Working with Age: it's not the same as a TimeSpan![^]

Posted 5-Oct-16 8:38am

OriginalGriff

Comments

Maciej Los 5-Oct-16 15:13pm

5ed!

Solution 3

Well, at this moment we know only that Ageing field is not getting increased, but we don't know what's wrong with your solution. And we know nothing about method used to increase that field!

So, i'd suggest to start with reading article provided in solution 1 by OriginalGriff[^].

If you would like to calculate the difference in days between two dates, you can use something like that:

C#

DateTime startDate = new DateTime(2016,10,2);
DateTime endDate = new DateTime (2016,10,5);

var daydiff = (endDate-startDate).TotalDays;
//returns: 3

But... if you would like to calculate it on SQL Server, you have to use DateDiff function[^]:

SQL

SELECT DATEDIFF(DD, '2016-10-02', '2016-10-05') AS Ageing
--returns: 3

Good luck!

Posted 5-Oct-16 9:28am

Maciej Los

Comments

Faran Saleem 5-Oct-16 23:38pm

That is what i am saying.. i am able to calculate the difference between two dates but i am not able to create the logic of how can i keep the Agein field getting increased with each passing day.
Thats where i need some help. Once the user submits the form, the agein field will be 0 for the first day but it should get increased to 1 automatically for the next day and then 2 and so on

Maciej Los 6-Oct-16 1:57am

Wrong approach! You don't need to store "age". All you need is to save initial date, bacause you can always calculate "age" from that date to today.

Maciej Los 6-Oct-16 2:04am

Wrong approach! You have to store only date, because you can calculate age from that date to today.

Maciej Los 6-Oct-16 2:04am

Wrong approach! You have to store only date, because you can calculate age from that date to today.

Maciej Los 6-Oct-16 2:06am

Wrong approach! You don't need to store "age" in your database. You have to calculate it each day.

Solution 4

Easy parse from string into Datetime;

C#

DateTime TotalDays = DateTime.ParseExact(sample.text,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture);
String Ageing = (DateTime.Now.Subtract((DateTime)TotalDays).Days).ToString();

Posted 9-Oct-16 21:09pm

koklimabc

Updated 9-Oct-16 21:26pm

v2

Solution 6

You can also find the age using below extension method.
Simply pass the DateOfBirth as argument.
There are many alternatives to achive the result.

C#

public static int GetAge(DateTime birthDate)
{
    DateTime n = DateTime.Now; // To avoid a race condition around midnight
    int age = n.Year - birthDate.Year;

    if (n.Month < birthDate.Month 
        || 
        (n.Month == birthDate.Month && n.Day < birthDate.Day)
       )
        age--;

    return age;
}

Posted 11-Oct-16 2:04am

Delvadiya Dipak

Updated 11-Oct-16 2:08am

v3

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)

Faran Saleem · Accepted Answer · 2016-10-10T22:58:00

Thank you all for your help. I really appreciate it. Thanks a ton.

I solved this through SQL Stored procedure from where i was calling my table.
I created a dateDiff function and subtracted the current date from date of submission and used Aliasing. Now it is calculating Ageing perfectly.

Thanks alot everyone again. Your help means alot.. :)

Calculate ageing in ASP.NET from the date of submission

5 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us