Forum Discussion
Calculating age from a date and time
I'd be extreemly grateful if someone could help with this. I have a column containing date and time information. From this I need to create a new column which shows the age based on the date (in days...
Anonymous
Use "New Column" not "New Measure"
RayL
Advocate I
Advocate IFYI-
another quick way to convert DOB to age:
- In Query Editor> select the column that contains DOB
- Go to Date & Time Colmn section > Date> Select "Age"
- In Date & Time Colmn section > Duration > Select "Total Years"
- Highlight the transformed column, right click and select "Change Type"> Select "Whole Number"
- Rename the column
One issue with this method is that for anyone that is over 6 months into their "current" age, their age will be rounded up. E.g. 26.7 will be rounded up to 27.
The solution to this is before you convert the column to a whole number, instead right click on the column header and go to Transform -> Round -> Round Down.
I had similar requirement of calculating age from DOB.
This is the easiest way to implement.
Thank you!!
AkshayMankeHelper II
What a Fantastic Way RayL, Many thanks for Sharing.!
