Focal Point
[SOLVED] The date is 41st November!

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4621077803

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,


____________________
764_XP
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.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
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.


____________________
764_XP
November 27, 2008, 04:12 PM
Francis Mariani
Take a look at this: [CODE] Simplifying the use of Date functions in Dialogue Manager


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