I am trying to get the a specific date using age and create_date For example Age varchar Age= 23 create_date date Create_date = 12-22-2019
The output should be 12-22-1996 This is to find the dateofbirth
I have
Case when age is not null then datediff(year, create_date, age) end
But this only gives me a year and I need the whole date.