I'm trying to get the current date and time using the code below:
-SET &TODAY=EDIT(&YYMD, '99999999');
-SET &TIME=HHMMSS('A8');
DEFINE FILE CONTACT
TODAY/YYMD=&TODAY;
TIME1/A8=&TIME;
END
TABLE FILE CONTACT
PRINT
TODAY
TIME1
END

But I receive this error every time:
0 ERROR AT OR NEAR LINE 5 IN PROCEDURE mav_ext_manual_lca
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: 10.39.59
0 ERROR AT OR NEAR LINE 10 IN PROCEDURE mav_ext_manual_lca
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: TIME1
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

What am I doing wrong?

This message has been edited. Last edited by: Kerry,

Alpha columns require quotes...

TIME1/A8='&TIME';

You may also have to add quotes for the yymd field ( TODAY/YYMD='&TODAY'; ).

Hey Gamp,

DM treats the TODAY output the same; actually, the answer comes via multiple paths up the WebFOCUS mountain:

You can do this:

 
-SET &TODAY=EDIT(&YYMD, '99999999');
-SET &TIME= '''' || HHMMSS('A8') | '''';
DEFINE FILE WHATEVER
   TIME1/A8      = &TIME;

OR, my response above,

OR

  
DEFINE FILE WHATEVER
 CUR_DATE/A10  = '&DATEYYMD';
 TIME1/A8      = HHMMSS('A8');

Whatever floats your boat!!!

Yeah Tom, I know, there are many ways to do something right (or wrong of course).
As long as the bottom line is that the problem gets solved ....

Do you really want to get the date and time separately? If not, you can use the HGETC function.

HGETC worked great! Thanks!!