I have tried to get the current year (2005), with the following statements:
helpfield = DatePart("yyyy", vbLongDate)
helpfield = DatePart("yyyy", vbDate)
The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1.
The second statement gives me the year 1900; in debugging I can see that vbDate = 7.
I am running Windows XP Professional, Microsoft Access 2002 (SP3), Microsoft Visual Basic 6.3.
Thanks for any help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!