6 Replies Latest reply on Aug 5, 2015 2:07 AM by kemaloznoyan

# How to add days to Get(CurrentDate)

### Title

How to add days to Get(CurrentDate)

### Post

I would like to create a field that would automatically take the currentdate and add 10 days to it.

Example

current date: February 26, 2009

What I want:

Currentdate + 10 days: March 8, 2009

• ###### 1. Re: How to add days to Get(CurrentDate)

Hi Thicks

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

• ###### 2. Re: How to add days to Get(CurrentDate)

Hi Orlando

wasn't it simpler if the calc was:

Get ( CurrentDate ) + 10

?

BTW: the important thing to say is that the calculation must be UNSTORED.

• ###### 3. Re: How to add days to Get(CurrentDate)

Yep you are right Danielle much simpler, me just over complicating things again.

• ###### 4. Re: How to add days to Get(CurrentDate)

Hello All,

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..

• ###### 5. Re: How to add days to Get(CurrentDate)

You should start a new thread.

Use a case statement;

Case(

(End Date < Get(CurrentDate);"Expired";

(End Date > Get(CurrentDate) + 20;"Time Exist";

)

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....

• ###### 6. Re: How to add days to Get(CurrentDate)

Thanks Steve,

It worked.. Sorry for late reply..

Kemal