Hi All,
I have date values in DMYY format. I want to display it into Month,year format. i.e Suppose the date value is 20/03/2013 I want to display it as 'March,2013'. I want to do it maintain. Is there any function available for this? Please suggest.

Thanks in advance.

This message has been edited. Last edited by: <Kathryn Henning>,

Convert the date into MYY format and then use DATETRAN.

declare mdate/MYY;
.
.
.
Case convert
repeat dateStack.foccount i/i4=1;

  mdate = dateStack(i).DATE;
  displayDate = DATETRAN(mdate,'(MYY)','(trc)','EN',15,displayDate);

endrepeat i=i+1;
EndCase

You can also take the displayDate value and place it straight back into an MYY field if required.

Thanks Alan. It worked.

Best Regards,
Anil

You could avoid using the subroutine and just have:

MAINTAIN
COMPUTE TODAY/MDYY='03042013';
COMPUTE THEN1/MtrYY = TODAY;
TYPE "<END

This will do it as well.
Mark

Hi Alan,
If there is NULL value for date it is displaying value 'December, 1900'. How to avoid it? Please suggest.

Thanks.

displayDate = if dateStack(i).DATE is missing then ' ' else DATETRAN(mdate,'(MYY)','(trc)','EN',15,displayDate);

If you bring the field back in, then you will have to set the date to missing if displayDate is blank.

@Mark
The format MtrYY will display 'APR 2013' not 'April, 2013'. Suspect it should display 'April, 2013', but it doesn't.