I need to put the date/time stamp in the output file name in the format YYYYMMDDHHMMSS(20130923141123) without any decimals in between. Is there a function or system variable that would give me that in Webfocus. The ones I came across put a dot to seperate e.g. minutes from seconds. Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,

texgator,

Would the below code work for you?

  
-SET &HOUR    = EDIT(&TOD,'99');
-SET &MINUTES = EDIT(&TOD,'$$$99');
-SET &SECONDS = EDIT(&TOD,'$$$$$$99');

-SET &TIME = &YYMD||&HOUR||&MINUTES||&SECONDS;

-TYPE DATE_TIME_STAMP : (&TIME)

Please let me know.

prodrigu

You could also try the Timestamp functions.

-SET &TS = HCNVRT(HGETC(8, 'HYYMDs'), '(H17)', 17, 'A17') ;
-TYPE Timestamp = &TS

Thanks guys!

If this is solved, then pleasse edit your first post in this thread and add [CLOSED] or [SOLVED] to it.