I’ve got a range of data that is only filtered by the users D.O.B in the format Y/M/D, since it’s a lot of data I need to clear it up so it shows their age. Is there a way to calculate the users age from their D.O.B to now? I’m unsure on queries and how to filter this particular task. So for example one of the dates is 1992/08/29 and to work out their actual age it would mean their birthday this year would be 2018/08/29. I’d want to know what the number is of that age range which of course would be the users age. I want to do this for all users.
Also is there any manual way to group age range? E.g. 24-29 30-35 etc
Thank you in advance