Ad:

VB.NET Discussion Thread
Unsolved
Views: 3166

Dec 11th, 2008

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

Expand Post »

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

Similar Threads

Device Problem in Windows 95 / 98 / Me
This ought to be simple - extra spaces in PHP
Page cannot be displayed in Web Browsers

manoj_582033

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

39 posts
since Nov 2008

Permalink

Dec 11th, 2008

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

hi,

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

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

reena12

Reputation Points: 12

Solved Threads: 4

Light Poster

Offline

32 posts
since Oct 2008

Permalink

Dec 11th, 2008

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

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

manoj_582033

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

39 posts
since Nov 2008

Permalink

Dec 11th, 2008

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

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

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

NEo4

Reputation Points: 27

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: complete records between two dates

Next Thread in VB.NET Forum Timeline: Threads and shared data problem

DaniWeb Message

Cancel Changes

User Name
Password