It looks like you're new here. Sign in or register to get started.
I have a birthdate field in dd/mm/yyyy? How do you compute age using Generate Attributes?
date_diff(date_now(),birthday)/(1000*60*60*24*365.25)
Thanks Thomas, any idea why I am getting negative values and decimal in my age field?
Try '(Birthday,date_now())' instead. I went off my faulty memory, check the date_diff() function requirements.
Answers
date_diff(date_now(),birthday)/(1000*60*60*24*365.25)
Thanks Thomas, any idea why I am getting negative values and decimal in my age field?
Try '(Birthday,date_now())' instead. I went off my faulty memory, check the date_diff() function requirements.