B
Bob Zimski
How do I get the following to give me 2009 instead of 1899 in immediate window?
? Year(today)
produces 1899 rather than 2009
? Year(today)
produces 1899 rather than 2009
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
TODAY is a worksheet function, not a VB one. Use either one of these
instead...
? Year(Now)
? Year(Date)
instead...
? Year(Now)
? Year(Date)
E
egun
Debug.Print Year(Now)
HTH,
Eric
HTH,
Eric
J
Jim Cone
Or try...
?year([today()])
--
Jim Cone
Portland, Oregon USA
"Bob Zimski"
<[email protected]>
wrote in message
How do I get the following to give me 2009 instead of 1899 in immediate window?
? Year(today)
produces 1899 rather than 2009
?year([today()])
--
Jim Cone
Portland, Oregon USA
"Bob Zimski"
<[email protected]>
wrote in message
How do I get the following to give me 2009 instead of 1899 in immediate window?
? Year(today)
produces 1899 rather than 2009
D
Dick Kusleika
TODAY is a worksheet function, not a VB one. Use either one of these
instead...
? Year(Now)
? Year(Date)
In addition, under VBE - Tools - Options, check Require Variable
Declaration. That way VBA would not try to interpret 'today' as a variable.
And it's just good practice.