Hi-
I'm trying to figure out the easiest way to write these formulas.
My data is stored by company by row with ten date columns. (See xls file)
I want to add a date diff between each date progression, but if there is a null I want to skip it and move to the next column.
example:
if ISNULL({statusdate2}) then DateDiff ("d",StatusDate1},CurrentD
if ({statusdate2} >#01/01/2009#) then then DateDiff ("d",{StatusDate1},{Status
But there seem to be so many variations of what could happen - is there an easier way to do this?
Thanks, Stacy
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi-
I'm still working on this problem:
Each formula works fine but when I try to stack them to cover all possiblitied - they don't work
My formulas work like this:
@date01-02: is the date diff between date1 and date2 fields
@date02-04: is the date diff between date2 and date4
etc
The stages are other forumulas from the precious scenerio:
example:
@stage2: {@date01-02}
@stage3: if ISNULL ({@date01-02}) then {@date01-03} else {@date02-03}
@stage4: if ISNULL({@stage2}) and ISNULL({@stage3}) then {@date01-04} else
if {@stage2}>0 and ISNULL({@stage3}) then {@date02-04} else
if {@stage3}>0 then {@date03-04}
Now stage2 and stage3 are working fine -
But stage4 is not - each line works fine - but they don't seem to work stacked - do you see anything that I am missing?
Thanks, Stacy
Hi-
So I saw another post by someone regarding nulls in crystal and they said:
" > In general, when Crystal Reports encounters a null valued field in a
> formula, it immediately stops evaluating the formula and produces
> no value. "
that seems to be my issue I believe.
I'm going to try and rewrite the formulas using NOT IS NULL -- but if you have any other suggestions pls let me know.
Thanks, Stacy
Business Accounts
Answer for Membership
by: mlmccPosted on 2009-10-22 at 07:47:35ID: 25634853
You need to define what happens in each case.
You want to get the date difference between consecutive pairs?
Status2 - Status1
WHat about Status3?
mlmcc