>i have a date in this format 990601
>i used this expresion to get 06/01/99
>substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2)
>
>what do i need to add to the expression to get June/01/99
>can anybody help me... i know that i need to use CMONTH() but i dont know how and where to place it
If your current date setting (SET DATE) is already in the M/D/Y format, then all you would need to do is:
dVar = substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2)
cMon = CMONTH(CTOD(dVar))