June 16, 2006, 04:56 AM
Tony ACome on Prarie, don't forget -
COMPUTE ODA8/A8YYMD = ORDER_DATE ;
COMPUTE ODMD/A5 = EDIT(ODA8, '$$$$99/99') ;
T
June 16, 2006, 07:51 AM
AshokI have recently come across this problem of extracting the day and month separetely from the date field. We have a function available to do this. It works fine.
HNAME(DATE, 'MONTH', MON)
HNAME is the function
DATE is the original field which contains the
date
MONTH is the field you want to extract
MON is the temporary field which I have created to stroe the extracted month value
To do this Go to Define option, click on new button...Give the name for your temporary field...Select the function button..Under category select date & time..HNAME is the function....& so on...
Please let me know if it does not work..
Regards,
Ashok Kumar M
June 16, 2006, 09:22 AM
PrarieYes Tony...that's better..brain was not working..that late in the day.