As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
Connect to myibi
Read-Only TopicGo
Search
Notify
Admin
New PM!
<d3nis370> posted October 22, 2010 10:06 AM
I am trying to do two things. One is take a date and add 30 to it. This is what I have so far. Also the LAST_CONTACT_DT is in P9 format.
DEFINE FILE FDI001 NEXTFOLLOWDATE/YYMD=FDI001.FDI001.FDI001_LAST_CONTACT_DT + 30
When I display NEXTFOLLOWDATE it returns this
Last contact dt 20100820 Next follow date 20100850
It should show
Last contact dt 20100820 Next follow date 20100919
The next thing I am trying to do is see how many days open an account has been. This is what I have so far. Also DT_REPORTED is in P9 format.
DEFINE FILE FDI001 CurrentDate/P9=20100903; BEGDTI/I8YYMD=CurrentDate; ENDDTI/I8YYMD=FDI001.FDI001.FDI001_DT_REPORTED; BEGDT/YYMD=ENDDTI; ENDDT/YYMD=ENDDTI; DIFFDAYS/I4=BEGDT - ENDDT;
Once I display DIFFDAYS all I get are 0.
This message has been edited. Last edited by: Kerry , November 02, 2010 01:45 PM
Master ...read the manual...!
What is WF suppossed to do with +30 ?
+30 days?
+30 hours?
+30 months?
use the help!
Ironicly... search for : DATEDIF
Do tell you didn't even try that...
Greets,Dave
_____________________ WF: 8.0.0.9 > going 8.2.0.5
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010
IP
Expert Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
IP
Expert FYI
The reason why your second option did not work is that you set the Begin and End dated the same.
BEGDT/YYMD=ENDDTI;
ENDDT/YYMD=ENDDTI; As for adding a value to a date, if its stored ina P9, then its a number, you need to convert to a Smart Date, as you did in your second option.
This is basic stuff.
Waz... Prod: WebFOCUS 7.6.10/8.1.04 Upgrade: WebFOCUS 8.2.07 OS: Linux Outputs: HTML, PDF, Excel, PPT In Focus since 1984 Pity the lost knowledge of an old programmer!
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006
IP
Ignored post by
Waz
posted
October 24, 2010 04:39 PM Show Post
Please Wait. Your request is being processed...
Read-Only TopicCopyright © 1996-2020 Information Builders