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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to count age in dbase
- Thread starter stv2005
- Start date
- Thread starter
- #2
- Thread starter
- #3
i've figured it out... yahoo!!
I'm actually counting age in month for babies. the following code is what wrote:
.replace age with (month(date())+(12*year(date())))-(month(childdob)+(12*year(childdob))) for day(date())>=day(childdob)
.replace age with (month(date())+(12*year(date())-1)-(month(childdob)+12*year(childdob)) for day(date())<day(childdob)
anyone can help me to test whether this set of code have any bug? hopefully it's correct, i'm going to test it right away.
I'm actually counting age in month for babies. the following code is what wrote:
.replace age with (month(date())+(12*year(date())))-(month(childdob)+(12*year(childdob))) for day(date())>=day(childdob)
.replace age with (month(date())+(12*year(date())-1)-(month(childdob)+12*year(childdob)) for day(date())<day(childdob)
anyone can help me to test whether this set of code have any bug? hopefully it's correct, i'm going to test it right away.
Can your version process the IIF() function? If so then you can combine it into one command rather than 2. Harder to read with all those parantheses, but more compact.
dbMark
Code:
replace age with (month(date())+(12*year(date())-IIF(day(date())<day(childdob),1,0))-(month(childdob)+12*year(childdob))- Status