November 27, 2008, 06:36 AM
minos4 [SOLVED] The date is 41st November!
Just try the following codes, see what you'll get!
-SET &ECHO = ALL;
-SET &CREATEDATE = TODAY('A10');
-SET &EDITDATE = EDIT('&CREATEDATE.EVAL','$$$$$$9999') || EDIT('&CREATEDATE.EVAL','99$$$$$$$$') || EDIT('&CREATEDATE.EVAL','$$$99$$$$$');
-SET &SOMETHING = DATEADD(&EDITDATE.EVAL, 'D', 14);
-TYPE &SOMETHING
-EXIT
This message has been edited. Last edited by: minos4 , November 27, 2008 07:59 AM November 27, 2008, 06:52 AM
susannah you've used the wrong function
you need to use AYMD on &variables.
DATEADD only works on defined or extant database variables with specified formats.
Kindly tone down your blasphemy.
-s.
November 27, 2008, 07:00 AM
<JG> DM is the problem, never has been able to manage dates particularly well.
code it like
DATECVT(DATEADD(DATECVT(&EDITDATE.EVAL,'I8YYMD','YYMD'),'D',14),'YYMD','I8YYMD');
November 27, 2008, 07:59 AM
minos4 Thanks, problem solved.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 27, 2008, 04:42 PM
Francis Mariani Did you know that
-SET &CREATEDATE = TODAY('A10');
-SET &EDITDATE = EDIT('&CREATEDATE.EVAL','$$$$$$9999') || EDIT('&CREATEDATE.EVAL','99$$$$$$$$') || EDIT('&CREATEDATE.EVAL','$$$99$$$$$');
could be replaced by
-SET &EDITDATE = &YYMD; Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server