All you need to do is write you calculation as follows:
Let ( Today = Get ( CurrentDate ) ;
Date ( Month ( Today ) ; Day ( Today ) + 10 ; Year ( Today ) )
I hope this helps
wasn't it simpler if the calc was:
Get ( CurrentDate ) + 10
BTW: the important thing to say is that the calculation must be UNSTORED.
Yep you are right Danielle much simpler, me just over complicating things again.
I created a field which will give some messages in it.
Can you tell me what is wrong in my formula?
If ( Last Loading Date < Get(CurrentDate) - 15 ; "Risky" ;If (End Date < Get(CurrentDate);"Expired"; If (End Date > Get(CurrentDate) + 20;"Time Exist" )))
Because Risky and Time Exist works but Expired does not..
Thank for your help in advance
You should start a new thread.
Without know much about your design see if this may help.
Use a case statement;
( Last Loading Date < Get(CurrentDate) - 15 ; "Risky" ;
(End Date < Get(CurrentDate);"Expired";
(End Date > Get(CurrentDate) + 20;"Time Exist";
"No Results" // I made this your default answer in case the whatever you are evaluating doesn't fall into those 3 criteria
The case statement will stop evaluation and return the first True result, so you may have to reorder them.
P.S. @ Orlando....Daniele, not Danielle....
It worked.. Sorry for late reply..