Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: Dates subtraction


Message #1 by Talon Wolles <ta_iwo@y...> on Sat, 15 Feb 2003 17:15:00 -0800 (PST)
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

  Return to Index