Calculate date subtraction and addtion

Question

0.00/5 (No votes)

See more:

hai....

I have a pdf file I am generating code for extract data from pdf to excel sheet

C#

if (listBox1.Items[i].ToString().Contains("ONLY Page 1 of 5 "))
{
    dr[5] = listBox1.Items[i + 2].ToString().Trim();
}

dr[5] gives the value of date what is in pdf(ex:12/31/2016)
but i want in dr[5] subtract 7 days in dr[5] and add 15 days resulted date

For example my date is 12/07/2016

12/07/2016 - 7days + 15 days =12/15/2016

What I have tried:

C#

if (listBox1.Items[i].ToString().Contains("ONLY Page 1 of 5 "))
{
   dr[5] = listBox1.Items[i + 2].ToString().Trim();
}

I have no idea

Posted 13-Dec-16 21:03pm

Member 12901328

Updated 13-Dec-16 21:26pm

StM0n

v2

Add a Solution

Comments

StM0n 14-Dec-16 3:17am

Not quite sure what you're trying to accomplish... but why don't you just add 8 days?

What type is in dr[5]... if it is a string, you have to convert it into a DateTime then just add your days.

2 solutions

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)

Michael_Davies · Answer 1 · 2016-12-13T21:17:00

Convert the string to a datetime variable and use the datetime methods;

C#

DateTime date1 = DateTime.Parse("12/07/2016",
               System.Globalization.CultureInfo.InvariantCulture).AddDays(-7);
 date1 = date1.AddDays(15);

Why not just add 8 days instead of -7 + 15?

Only difficulty is making sure the string has the month and day the right way round check out MSDN.

DateTime Structure (System)[^]

Jochen Arndt · Answer 2 · 2016-12-13T21:26:00

You have to convert the string representing a date to a numeric date representation (DateTime Structure (System)[^] with C#). Then use that to perform the calculation (see the DateTime.Add[xxx] functions). To print the date out use DateTime.ToString. Because you want to pass it to Excel, it would be better to use the numeric value and pass that to Excel (which might require setting the cell format depending on the used export method).

The problem is that there are many different date formats. But if you know the exact format the conversion is no problem (use DateTime.[Try]ParseExact). Otherwise use DateTime.TryParse to check if the string was recognised as date.

Calculate date subtraction and addtion

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0