How to subtract the date from two datetimepicker?

Question

0.00/5 (No votes)

See more:

Hi,

I'm using VB in visual studio 2008. Anyone know what are the codes to subtracting 2 datetimepickers to determine the number of days? i'm doing a project for employee leave management system. And it is essential that i count how many days the employee has take a leave. I need to fill an empty textbox with the no. of days.

Thanks in advance.

Posted 9-Jul-12 20:50pm

Rickysay

Add a Solution

1 solution

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)

Prasad_Kulkarni · Answer 1 · 2012-07-09T20:52:00

Solution 1

Try this:

C#

DateTime beginDate = DtpDateRetour.SelectedDate;
DateTime endDate = DtpDateLocation.SelectedDate;
dateDifference = beginDate.Subtract(endDate);

For more refer:
http://msdn.microsoft.com/en-us/library/system.datetime.compare.aspx[^]

Similar discussion:
how to calculate difference between two date[^]

Posted 9-Jul-12 20:52pm

Prasad_Kulkarni

Updated 9-Jul-12 20:56pm

v2

Comments

Rickysay 10-Jul-12 3:02am

How do i insert the code onto my Private Sub btn_Click?

Rickysay 10-Jul-12 3:16am

I want to use this on Sub procedure not using void commands.

Prasad_Kulkarni 10-Jul-12 3:33am

What is the problem? What is the problem in code. dateDifference = beginDate.Subtract(endDate); use this code on your button click which will give you date difference.

Rickysay 10-Jul-12 3:36am

Private Sub btnCalcDaysTaken_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalcDaysTaken.Click
Try

DateTime(beginDate = dtpFrom.SelectedDate)
DateTime(endDate = dtpTo.SelectedDate)
dateDifference = beginDate.Subtract(endDate)

Catch ex As Exception

MessageBox.Show(ex.Message)

End Try
End Sub

It says datetime is a type and cannot be used as an expression.

Prasad_Kulkarni 11-Jul-12 1:58am

You need to specify datatype for datetime
use TimeSpan dateDifference = beginDate.Subtract(endDate)

Rickysay 10-Jul-12 22:15pm

How do i put this on the above code? Do i need to declare a datatype first? Help me out please.

Rickysay 10-Jul-12 22:51pm

hello??? Anyone? I've tried for hours to make the codes to work? But it ain't helping a bit. Please someone?

Sean Donnahoe 8-Feb-13 9:42am

I get so many errors from this code in VS2012-VB. I simply want to find the difference between the selected dates in my two datepicker objects (DateIn & DateOut). If the difference is less than 7 I want a checkbox to be checked, greater than 7 days, unchecked. None of the solutions I have found on this site have helped at all.

Prasad_Kulkarni 12-Feb-13 2:26am

Try this:
textBox1.Text = (dateTimePicker2.Value - dateTimePicker1.Value).TotalDays.ToString("#");

Member 13360138 2-Oct-17 22:36pm

Thanks sir