Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

breaking age into year and month

Status
Not open for further replies.
barny2006

barny2006

MIS
Joined
Mar 30, 2006
Messages
521
Location
US
hi,
is there a way to use modula or something like that to break age into years and month accurately in a single expression?
thanks.
 
Sort by date Sort by votes
Barny2006 -

Can you provide a unit for age? Is it months, days, minutes?

Thanks

strebor
 
Upvote 0 Downvote
how about this

Code: 
birthday = "5/30/1962"

TotalMonthsOld = DateDiff("M",birthday,Now())
YearsOld = TotalMonthsOld/12
MonthsOld = TotalMonthsOld - (Int(YearsOld)*12)
TotalDaysOld = DateDiff("D",birthday,Now())
WScript.Echo "You are " & Int(YearsOld) & " Years, " & MonthsOld & " Months Old."

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

asel
  • Locked
  • Question Question
Copy cell data from excel and paste into portable software application
Replies
0
Views
362
asel
asel
HuronBaloo
  • Locked
  • Question Question
Outlook Appointment object - yearly recurring (i.e. anniversary)
Replies
0
Views
551
HuronBaloo
HuronBaloo
Katto
  • Locked
  • Question Question
Paste picture from clipboard into aslide of an opened powerpoint file
Replies
0
Views
420
Katto
Katto
shilpa2002
  • Locked
  • Question Question
how to copy data from two excel workbooks into third. merging data based on common field
Replies
3
Views
556
SkipVought
S
Don Child
  • Locked
  • Question Question
JScript to search for specific outlook emails, and download attachments
Replies
8
Views
1K
Eric J
Eric J

Part and Inventory Search

Sponsor

Back
Top