Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 15th, 2008, 08:15 AM
Registered User
Join Date: Aug 2008
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using Date in Visual Basic 2005.

How to get age in years(rounded off to nearest number) in a textbox3,suppose we are having Date of birth of a person in textbox2 and today's date in textbox1?

Old August 15th, 2008, 09:42 AM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

Something like this:
  Year(CDate("January 15, 2008")) - Year(CDate("September 9, 1985"))
almost gives you the answer. But it is only accurate after 9/9 any year. So if the date is after December 31, midnight (after New Year's), but before the birthday, you need to subtract 1.

Statements that are True or False = -1 if True, and 0 if False.

Adding a minus value subtracts the absolute value of it.

So if you [u]add</u> to the statement’s value (the purple part is pseudocode)
  + (TheDayOfTheYearOf(CDate(textbox1.Text)) < _
     TheDayOfTheYearOf(CDate(textbox2.Text)) _

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic 2005 Express CForce Visual Basic 2005 Basics 1 June 22nd, 2008 10:21 PM
visual basic 2005 nidhigupta001 Visual Basic 2005 Basics 1 February 12th, 2007 08:26 AM
visual basic 2005 nidhigupta001 Visual Basic 2005 Basics 2 February 11th, 2007 04:06 PM
Visual Basic 2005 Express Edition thomasks BOOK: Beginning VB.NET Databases 8 January 3rd, 2007 02:11 AM
FTP in Visual Studio 2005 Pro (Visual Basic) shoopes VB How-To 1 June 29th, 2006 02:08 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.