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.
When I display NEXTFOLLOWDATE it returns this
It should show
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.
Once I display DIFFDAYS all I get are 0.This message has been edited. Last edited by: Kerry,
...read the manual...!
What is WF suppossed to do with +30 ?
use the help!
Ironicly... search for : DATEDIF
Do tell you didn't even try that...
WF: 126.96.36.199 > going 188.8.131.52
http://forums.informationbuild...731069712#4731069712 c/o: Mickey
The reason why your second option did not work is that you set the Begin and End dated the same.
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.
|Powered by Social Strata|