Working with dates

[madhu]

Hi guys,

I was working with some clinical data where I need calculate the age from date of birth variables and current date variable.But the date of birth variable is divided into three different variables as day, month and year.How do i do this.

[deleted_user]

You can use MDY() function.

[SushilNayak]

suppose the 3 birth date vairables are brtyr (birth year) brtmon( birth month) and btrdat (bith date).
Then just do
birth_dt=mdy(brtmon,btrdat ,brtyr);
age=int((today()-birth_dt)/365.25);

hope that helps.

[madhu]

Thanks guys!!