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 dencom 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
Mar 30, 2006
521
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
Copy cell data from excel and paste into portable software application
Replies
0
Views
251
asel
asel
HuronBaloo
  • Locked
  • Question
Outlook Appointment object - yearly recurring (i.e. anniversary)
Replies
0
Views
317
HuronBaloo
HuronBaloo
Katto
  • Locked
  • Question
Paste picture from clipboard into aslide of an opened powerpoint file
Replies
0
Views
274
Katto
Katto
shilpa2002
  • Locked
  • Question
how to copy data from two excel workbooks into third. merging data based on common field
Replies
3
Views
352
SkipVought
S
Don Child
  • Locked
  • Question
JScript to search for specific outlook emails, and download attachments 2
Replies
8
Views
780
Eric J
Eric J

Part and Inventory Search

Sponsor

Back
Top