Thanks Peter N Kipe, Mark Roworth, Malathi and Bill
Franklin (not in any order). The Datediff function
does what I want. Thank you all.
-Talon
--- "Peter N. Kipe" <pkipe@c...> wrote:
> Dim a As Date
> Dim b As Date
> Dim c As Integer
>
> a = Now
> b = DateAdd("d", 3, a)
> c = DateDiff("d", a, b)
> MsgBox c
>
> -----Original Message-----
> From: Talon Wolles [mailto:ta_iwo@y...]
> Sent: Saturday, February 15, 2003 8:15 PM
> To: professional vb
> Subject: [pro_vb] Dates subtraction
>
>
> Hi all,
> I think I can't think now. I want to subtract one
> date
> variable from another to give me numeric day value
> ie
>
> txtday= date1 - date2
>
> What is the syntax for this. I seem to be missing
> something out.
>
> -Talon
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Shopping - Send Flowers for Valentine's Day
> http://shopping.yahoo.com
>
>
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com