VB.NET

VB.NET RSS

how to find that a date exists in between two dates ?

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2008

Posts: 34

Reputation: manoj_582033 is an unknown quantity at this point

Solved Threads: 0

manoj_582033 manoj_582033 is offline

Offline

Light Poster

how to find that a date exists in between two dates ?

Dec 11th, 2008

Hi friends,

could anybody guide me , how to find that a date exists in between two dates ?

For example : 23/09/2008 -- 28/09/2008 - I'am on leave.
When a attendence is entered for the date 24/09/2008 , then i should get a msg saying, that the given date exists in the leave date.

In a leave table, i already store the above two dates and save. I will enter the attendence in the front end

•

Join Date: Oct 2008

Posts: 32

Reputation: reena12 is an unknown quantity at this point

Solved Threads: 4

reena12

Offline

Light Poster

Re: how to find that a date exists in between two dates ?

Dec 11th, 2008

hi,

fetch your leave start date and end date
startdate = stdt
enddate = nddt

if currentdate >= stdt AND currentdate <= nddt
{
msgbox (".....")
}

Reena Mehta

Remember to click on Mark as answer on the post that helped

http://www.indianic.com

•

Join Date: Nov 2008

Posts: 34

Reputation: manoj_582033 is an unknown quantity at this point

Solved Threads: 0

manoj_582033 manoj_582033 is offline

Offline

Light Poster

Re: how to find that a date exists in between two dates ?

Dec 11th, 2008

I did this condition but itis not working.
is there any other way to solve it

•

Join Date: Dec 2008

Posts: 10

Reputation: NEo4 is an unknown quantity at this point

Solved Threads: 0

NEo4

Offline

Newbie Poster

Re: how to find that a date exists in between two dates ?

Dec 11th, 2008

Put the date in a variable first and then compare them.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) _
                           Handles MyBase.Load
        Dim dateFrom As Date = New Date(2008, 12, 1)
        Dim dateTo As Date = New Date(2008, 12, 5)
        Dim dateAttend As Date = New Date(2008, 12, 3)
 
        If dateAttend > dateFrom And dateAttend < dateTo Then
            MessageBox.Show("You're are on holiday!")
        End If
    End Sub
    Private Sub Form1_Load(ByVal sender As System.Object, _
                           ByVal e As System.EventArgs) _
                           Handles MyBase.Load
        Dim dateFrom As Date = New Date(2008, 12, 1)
        Dim dateTo As Date = New Date(2008, 12, 5)
        Dim dateAttend As Date = New Date(2008, 12, 3)

        If dateAttend > dateFrom And dateAttend < dateTo Then
            MessageBox.Show("You're are on holiday!")
        End If
    End Sub