Year showing 1899 instead of 2009

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
 
R

Rick Rothstein

TODAY is a worksheet function, not a VB one. Use either one of these
instead...

? Year(Now)

? Year(Date)
 
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
 
D

Dick Kusleika

TODAY is a worksheet function, not a VB one. Use either one of these
instead...

? Year(Now)

? Year(Date)
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003-Date() = 12/30/1899 not 06/15/2009 why? 3
Pivot: grand totals 4
VBA for Month and Quarters Output 10
Determining Change in a cell Value.... 4
Order Query By TIME HELP? 4
Formatting Dates from 1700 & 1800s 1
Medium time text box shows year 3
Changing the Year in formatted Date 5

Top