All Forums Database
cmyeyez 11 posts Joined 02/13
17 Jan 2016
Return a specific date

How do I return the specific date of a persons 30th birthdate (past or future)
given the persons BIRTH_DATE?
I have a dataset of age ranges (24-64) and need to return the date of their 30th bday.
 
Thanks!

dnoeth 4628 posts Joined 11/04
17 Jan 2016

30 years are 360 months: ADD_MONTHS(BIRTH_DATE, 30*12)

Dieter

You must sign in to leave a comment.