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] Calculate Date in 5, 10, 15, 20 years Increment
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Calculate Date in 5, 10, 15, 20 years Increment
 Login/Join
 
Member
posted
I ordered "(Almost) 1001 Ways to Work with Dates in WebFocus" but in the meantime, I would like to know how you calculate the anniversary date (MDYY format) in 5, 10, 15, 20 etc. increment from the Start Date (MDYY Format). Can anybody show me how? I would appreciate it greatly! I use WebFocus 8.

Thanks,
joykairos

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


WebFocus Managed Reporting, Developer Studio
 
Posts: 6 | Registered: November 17, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Something like this perhaps? There may be more than this one method ...
DEFINE FILE CAR
NOW/MDYY = '&MDYY';
ANNIV1/MDYY = DATEADD(NOW,'Y',5);
ANNIV2/MDYY = DATEADD(NOW,'Y',10);
ANNIV3/MDYY = DATEADD(NOW,'Y',15);
ANNIV4/MDYY = DATEADD(NOW,'Y',20);
ANNIV5/MDYY = DATEADD(NOW,'Y',25);
END

TABLE FILE CAR
PRINT NOW ANNIV1 ANNIV2 ANNIV3 ANNIV4 ANNIV5
BY COUNTRY
BY CAR
END


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Thanks GamP! I am newbie so thanks for the tip!


WebFocus Managed Reporting, Developer Studio
 
Posts: 6 | Registered: November 17, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Calculate Date in 5, 10, 15, 20 years Increment

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