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!

calculate age

Status
Not open for further replies.
HRHK

HRHK

Programmer
Joined
Jun 5, 2005
Messages
83
Location
US
How do I correctly calculate age from data of birth in CR?
I can do following in Access but CR doesn't recognize the format function. Thanks.

DateDiff("yyyy",{my_age.birth_dte} , Now())+Int(format(Now(),"mmdd")<Format({my_age.birth_dte},"mmdd"))
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

PremHealth1
  • Locked
  • Question Question
Calculate Values Based Upon Cells in Different Cross-Tabs
Replies
1
Views
391
lbass
lbass
J33
  • Locked
  • Question Question
Calculate sum when project phase starts with a specific digit
Replies
1
Views
356
lbass
lbass
odins701
  • Locked
  • Question Question
Calculate who is onsite now
2 3 4
Replies
74
Views
3K
singletonamos50
singletonamos50
ClowneUser
  • Locked
  • Question Question
Calculate Qty depending on another field
Replies
2
Views
319
ClowneUser
ClowneUser
deangels3
  • Locked
  • Question Question
Calculate actual amount to be paid
Replies
0
Views
166
deangels3
deangels3

Part and Inventory Search

Sponsor

Back
Top