Seperate number columns into date

I had three number columns that I needed to concatenate as a date field. Here is what I figured out:
Appended a column, virtual date, and the following formula which concatenates and turns the number fields (@str) into a character field THEN "Character to Date":
 
 
@Ctod((@Str(MO,2,0)+@STR(DY,2,0)+@Str(YR,4,0)),"MMDDYYYY")
 
It provided the following date:
"mm/dd/yyyy