Forum Discussion
Solved
DATEDIFF with IF statement?
Hello :) I have made a column in my report table to calculate the age from the date of birth using DATEDIFF. Upon seeing the data, I realize that I need to add something so that if the age is less th...
My guess is you are getting converion errors with the IF? Try something like this:
Age = VAR AgeCalc = DATEDIFF ( [LaddersT.PersonT(PersonID).BirthDate], TODAY (), YEAR ) RETURN IF ( AgeCalc < 5, "Unknown", FORMAT ( AgeCalc, "00" ) )
My guess is you are getting converion errors with the IF? Try something like this:
Age =
VAR AgeCalc =
DATEDIFF ( [LaddersT.PersonT(PersonID).BirthDate], TODAY (), YEAR )
RETURN
IF ( AgeCalc < 5, "Unknown", FORMAT ( AgeCalc, "00" ) )
Hi - now that I have patient ages, I need to be able to pull all patients in a given time period and show how many people there are in each age group - age groups being <18, 18-39, 40-59, 60+.
Can you help me figure that out as well? Sorry - I wasn't thinking about this yesterday or I would have asked for both at the same time.
Thank you :)