View previous topic :: View next topic
|
Author |
Message |
harkar Warnings : 2 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. |
|
Back to top |
|
|
IQofaGerbil
Active User
Joined: 05 May 2006 Posts: 183 Location: Scotland
|
|
|
|
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 |
|
Back to top |
|
|
|