Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] DATEADD error
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] DATEADD error
 Login/Join
 
Silver Member
posted
The code below has been working fine until this morning. It determined that &POSTDT = '2019-10-00' and I do not understand that at all. Is there some other way I should be using to take the current days date and subtract one day?
  
-SET &CURDT = &YYMD;
-SET &PREVDT = DATEADD(&CURDT, 'D', -1);
-SET &POSTDT = EDIT(&PREVDT, '9999-99-99');


Thanks,

This message has been edited. Last edited by: FP Mod Chuck,


7.7, z/OS & Win7, excel & pdf
8.2 testing
 
Posts: 46 | Location: Tallahassee, FL ... was focused on, uh, what were we talking about? | Registered: February 03, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
If it's NOT a Smart Date, will "always" error; also, don't need &CURDT:

-SET &PREVDT = DATECVT((DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D',-1))'YYMD', 'I8YYMD');


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1948 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Are you guys really on 7.7x?
 
Posts: 3010 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Silver Member
posted Hide Post
Yup, although we are working towards 8.2.3 at the moment.


7.7, z/OS & Win7, excel & pdf
8.2 testing
 
Posts: 46 | Location: Tallahassee, FL ... was focused on, uh, what were we talking about? | Registered: February 03, 2012Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks Tom. I did have to tweak it a bit as it threw an unbalanced parentheses error.
-SET &PREVDT = DATECVT(DATEADD(DATECVT(&YYMD,'I8YYMD','YYMD'),'D',-1), 'YYMD', 'I8YYMD');  


7.7, z/OS & Win7, excel & pdf
8.2 testing
 
Posts: 46 | Location: Tallahassee, FL ... was focused on, uh, what were we talking about? | Registered: February 03, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
Cool Beans! Me and My Parens - should be a song!
Best Wishes with the upgrade...


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1948 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] DATEADD error

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.