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
AkshayManke
Helper II
Helper IIWhat a Fantastic Way RayL, Many thanks for Sharing.!