How to add days to Get(CurrentDate)
I would like to create a field that would automatically take the currentdate and add 10 days to it.
current date: February 26, 2009
What I want:
Currentdate + 10 days: March 8, 2009
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..
Retrieving data ...