islesrock36
Programmer
I am currently doing a report where i have to display a persons age in years month and days.I have the year and months figured out but not the days.
heres what i have so far
NumberVar DoBVar := IIF((100 * MONTH({Command.HCA_ASSMNT_DTE}) + DAY({Command.HCA_ASSMNT_DTE})) < (100 * MONTH({Command.GET_DTE_BRTH(A.CLNT_ID)}) + DAY({Command.GET_DTE_BRTH(A.CLNT_ID)})), 1, 0);
NumberVar MthVar := (DATEDIFF("m",{Command.GET_DTE_BRTH(A.CLNT_ID)},{Command.HCA_ASSMNT_DTE}) - DobVar) mod 12;
NumberVar YrsVar := DATEDIFF("yyyy",{Command.GET_DTE_BRTH(A.CLNT_ID)},{Command.HCA_ASSMNT_DTE}) - DobVar;
StringVar MthYrs := TOTEXT(YrsVar,0) + " years " + TOTEXT(MthVar,0) + " months" ;
heres what i have so far
NumberVar DoBVar := IIF((100 * MONTH({Command.HCA_ASSMNT_DTE}) + DAY({Command.HCA_ASSMNT_DTE})) < (100 * MONTH({Command.GET_DTE_BRTH(A.CLNT_ID)}) + DAY({Command.GET_DTE_BRTH(A.CLNT_ID)})), 1, 0);
NumberVar MthVar := (DATEDIFF("m",{Command.GET_DTE_BRTH(A.CLNT_ID)},{Command.HCA_ASSMNT_DTE}) - DobVar) mod 12;
NumberVar YrsVar := DATEDIFF("yyyy",{Command.GET_DTE_BRTH(A.CLNT_ID)},{Command.HCA_ASSMNT_DTE}) - DobVar;
StringVar MthYrs := TOTEXT(YrsVar,0) + " years " + TOTEXT(MthVar,0) + " months" ;