Add days to date Formula

Hi James,

You'll want to make use of the ifElse statement:

ifElse(empty($date_d_c), addDays($date_a_c, 259), addDays($date_d_c, 259))

I hope that helps!

-Alan

Wow. Thank you sir. VERY appreciated.

This looked like it should work for me, but in my formula builder, it will not accept  "empty."
It shows:

Invalid Formula

empty: No such function defined

Do you know what else can be used?

My apologies! Try this formula instead:

ifElse(equal($date_d_c, ""), addDays($date_a_c, 259), addDays($date_d_c, 259))

-Alan

THAT WORKED!! Im very grateful. Thank you!

Hi,

Can u please help me to built a formula in which i want to show the value of field due date on the basis of the filed category(A drop down with the value Hot,Warm,Cold)

I want to check if the value of category = Hot, then due date(by default populate value)= today + 1 days

if the value of category = Warm, then due date(by default populate value)= today + 3 days

if the value of category = Cold, then due date(by default populate value) = today + 5 days

And also user can change the due date manually.

Please reply ASAP

Hi Rahul,

The formula you'll want will look something like this:

ifElse(equal($category, "Hot"), addDays(today(), 1), ifElse(equal($category, "Warm"), addDays(today(), 3), addDays(today(), 5)))

In order to make the field editable, you need to modify the vardef so that the "enforced" value is set to false. More information on how to do this can be found here. Let me know if you have any issues or questions with this!

-Alan

Thanks Alan. Its working for me

Hi Alan,

Thanks for the solution you provided in your last reply.

I have a doubt regarding the default value for a single field in custom module.

I have created two  fields, Field 1(integer type) and Field 2(integer type). i want to make sure that if user enters no value in the Field 2 and save the form then the value of Field 2 should be saved equal to the value of Field 1 entered by the user.

if (Field2 == 0)

then

Field2 =  Field1 ;

I  want to know that how we can do it from studio.

Hi Alan,

Thanks for the solution you provided in your last reply.

I have a doubt regarding the default value for a single field in custom

module.

I have created two  fields, Field 1(integer type) and Field 2(integer

type). i want to make sure that if user enters no value in the Field 2 and

save the form then the value of Field 2 should be saved equal to the value

of Field 1 entered by the user.

if (Field2 == 0)

then

Field2 =  Field1 ;

I  want to know that how we can do it from studio.

On Thu, May 5, 2016 at 10:50 PM, Alan Beam <sugarcrm-public@jiveon.com>