I have a question to convert a date format (28/03/2004) to a string format (20040328). Is there any function or command to do this in WebFocus?
If the format of the field is "DMYY" then create a define such as this.
DEFINE FILE CAR
DATE1/A8DMYY = YOURDATEFIELD ;
DATE2/A8 = EDIT(DATE1,'$$$$9999') | EDIT(DATE1,'$$99') | EDIT(DATE1,'99') ;
Now you will have am Alphanumeric(text) field that is in YYYYMMDD order.
Thank you very much. It works fine !
or, using the DATECVT function which
changes the form of your smart date...
temp/YYMD = DATECVT(yourdate,'DMYY','YYMD' );
temp1/A8DMYY = temp;
RESULTDATE/A8 = temp1;
13/09/2004 2004/09/13 2004/09/13 20040913
|Powered by Social Strata|