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 strongm 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
Jun 5, 2005
83
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
Calculate Values Based Upon Cells in Different Cross-Tabs
Replies
1
Views
92
lbass
lbass
J33
  • Locked
  • Question
Calculate sum when project phase starts with a specific digit
Replies
1
Views
77
lbass
lbass
odins701
  • Locked
  • Question
Calculate who is onsite now 1
2 3 4
Replies
74
Views
185
singletonamos50
singletonamos50
ClowneUser
  • Locked
  • Question
Calculate Qty depending on another field
Replies
2
Views
61
ClowneUser
ClowneUser
deangels3
  • Locked
  • Question
Calculate actual amount to be paid
Replies
0
Views
34
deangels3
deangels3

Part and Inventory Search

Sponsor

Back
Top