Date difference and date compare

EMILYTAN via VBMonster.co · Joined: 04 Oct 2007 Posts: 2

1. May i know of the way to compare the dates between 2 dates?
2. I want to find the difference by day between 2 dates...

thank you

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vb-syntax/200705/1

Archived from group: microsoft>public>vb>syntax

MikeD · Joined: 04 Oct 2007 Posts: 3348

"EMILYTAN via VBMonster.com" wrote in message @uwe...
> 1. May i know of the way to compare the dates between 2 dates?

Look up the DateDiff function in VB's Help.

> 2. I want to find the difference by day between 2 dates...

See answer to #1.

--
Mike
Microsoft MVP Visual Basic

Tony Proctor · Joined: 04 Oct 2007 Posts: 1051

1) Use ordinary relational operators, e.g.

Dim dDate1 As Date, dDate2 As Date
dDate1 = #3/25/2007#
dDate2 = #12/25/2007#
Debug.Print (Date >= dDate1 And Date <= dDate2)

2) Use DateDiff function, as Mike said

If things are not working for you, maybe you could show us some example code

Tony Proctor

"EMILYTAN via VBMonster.com" wrote in message@uwe...
> 1. May i know of the way to compare the dates between 2 dates?
> 2. I want to find the difference by day between 2 dates...
>
>
> thank you
>
> --
> Message posted via VBMonster.com
> http://www.vbmonster.com/Uwe/Forums.aspx/vb-syntax/200705/1
>

EMILYTAN via VBMonster.co · Joined: 04 Oct 2007 Posts: 2

I will try on it first...
Thank you

Tony Proctor wrote:
>1) Use ordinary relational operators, e.g.
>
> Dim dDate1 As Date, dDate2 As Date
> dDate1 = #3/25/2007#
> dDate2 = #12/25/2007#
> Debug.Print (Date >= dDate1 And Date <= dDate2)
>
>2) Use DateDiff function, as Mike said
>
>If things are not working for you, maybe you could show us some example code
>
> Tony Proctor
>
>> 1. May i know of the way to compare the dates between 2 dates?
>> 2. I want to find the difference by day between 2 dates...
>>
>> thank you

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vb-syntax/200705/1