Hi Tariq,

just a word as advise. Only use alltrim when you really need it, which means practically never! In this code snippet you can remove all the alltrims!



>Dear Experts
>
>

>store space(10) to mn1,yr1,dd2,cvar1, mn12,yr12,dd22,cvar12,curmon
>store 0 to lnMonths,lnMonths2,lnMonths3
>Select year
>SCATTE MEMV
>dd1=dtoc(M.b_date) && 01-07-2005 type D
>mn1=alltrim(substr(dd1,4,2)) && separate month
>yr1=alltrim(right(dd1,4))    && separate year
>dd2=alltrim(mn1)+alltrim("-")+alltrim(yr1) && month & year
>
>dd12=dtoc(M.e_date) && 30-06-2006 type D
>mn12=alltrim(substr(dd12,4,2))&& separate month
>yr12=alltrim(right(dd12,4))   && separate year
>dd22=alltrim(mn12)+alltrim("-")+alltrim(yr12) && month & year
>

>
>Without Exe the values of variable dd2 and dd22 are
>
>Dd2 =”07-2005”
>Dd22=”06-2006”
>
>In Exe the values of variable dd2 and dd22 are
>
>Dd2 =”07-7-05”
>Dd22=”06-6-06”
>
>Why values of dd2 and dd2 are different in exe and without exe.
>
>Please help