How to get the current date with the format November 11,2006

harkar · New User Joined: 11 Nov 2006 Posts: 7 Location: Chennai

Hi,

Could some one help me in tellling me How to get the current date with the format November 11,2006 in Eazytrieve.

Thanks in advance,
Harkar.

IQofaGerbil · Posted: Mon Nov 13, 2006 8:57 pm

You could do it this way
1. get SYSDATE (the format of this is determined in your shop so check whether it is dd/mm/yy or mm/dd/yy or dd/mm/yyyy etc
2. define an array and extract the month using the MM value from SYSDATE
eg

DEFINE ARRAY-ELEMENT W 2 N
DEFINE MONTHS W 120 A VALUE +
?JANUARY +
FEBRUARY +
MARCH +
APRIL +
MAY +
JUNE +
JULY +
AUGUST +
SEPTEMBER +
OCTOBER +
NOVEMBER +
DECEMBER ?
DEFINE MONTH MONTHS 10 A +
OCCURS (12) INDEX (MONTH-INDEX)

JOB INPUT NULL
ARRAY-ELEMENT = ''the value of MM from SYSDATE''
MONTH-INDEX = (ARRAY-ELEMENT - 1) * 10
DISPLAY MONTH
STOP

go play