I am working with 7.1.7 Webfocus.
I am trying to execute the below code and connect the result to Dropdown box in HTML form.

DEFINE FILE COMPPLAN
EFF_FRMT/trMYY=EFF_YM;
END
TABLE FILE COMPPLAN
BY HIGHEST EFF_FRMT
WHERE EFF_FRMT NE ' ';
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
ON TABLE SET HTMLCSS ON
END

But Dropdown box has
'032011'
'022011'
which are suppose to be
'January 2011'
'February 2011'
etc

Any suggessions??

This message has been edited. Last edited by: Kerry,

There appear to be multiple challenges here.
First trMYY seems to be unknown; Do you mean MtrYY?
Additionally the format works on legacy dates such as A6YMD.
You may want reconsider the format of EFF_YM

Try

myyDate/MYY=EFF_YM;
showDate/A20=DATETRAN(myyDate,'(MYY)','(tr)','EN',20,'A20');

That code isn't working.

I tried even MtrYY, but isn't working.

I am not getting the result in format "January 2011".

Alan has the right idea.

As you are returning this to a drop down list, it would be safer to return a string instead of a date.

quote:

That code isn't working.

If you mean:

myyDate/MYY=EFF_YM;
showDate/A20=DATETRAN(myyDate,'(MYY)','(tr)','EN',20,'A20');

It is one of the few ways to achieve what you are after. It does work, I use it on various applications. Check what you are doing.

quote:

myyDate/MYY=EFF_YM;
showDate/A20=DATETRAN(myyDate,'(MYY)','(tr)','EN',20,'A20');

Works perfect, Alan.

  
APP PREPENDPATH IBISAMP
-RUN
DEFINE FILE GGSALES
MYYDATE/MYY=DATE;
SHOWDATE/A20=DATETRAN(MYYDATE,'(MYY)','(TR)','EN',20,'A20');
END
TABLE FILE GGSALES
SUM
  DST.SHOWDATE
 BY SHOWDATE NOPRINT
ON TABLE PCHOLD FORMAT XML
END
-EXIT