# Re: Add a number to a date formula help?

1439 0
cancel
Showing results for
Did you mean:
7 - App Architect

Hello-

Trying add a field that can add days to my formula, any thoughts?

IF({DC Arrival Date}=BLANK(), BLANK(),
IF(OR({Production Type} = ‘Domestic’,{Production Type} = ‘Puzzles’),

2 Replies 2
13 - Mars

@Scott_Gardner1 - If I’ve got the logic of your formula correct, I think you can do a little simplification:

``````IF(
{DC Arrival Date},
IF(
OR({Production Type} = 'Puzzles', {Production Type} = 'Domestic'),
)
)
``````

This says:

“if there is a DC Arrival Date, then if production type is Puzzles or Domestic, then add minus 56 days, but if not Puzzles or Domestic, then add minus 98 days”

What is implied in this formula is that if DC Arrival Date is blank then the resultaing date is blank.

This gives:

I tend to use “if field has a value/is not null” rather than “if field is blank”. “if field has a value” is represented by:

``````IF(
{DC Arrival Date},
``````

To make the “blank” date value explicit you could put:

``````IF(
{DC Arrival Date},
IF(
OR({Production Type} = 'Puzzles', {Production Type} = 'Domestic'),
i.e. add the `BLANK()` on the last line of the IF, but this is not a required element of the formula, so generally I leave this out if my final value is blank/null/empty