Details about this thread
  • State Verified Answer
  • Replies 12 replies
  • Subscribers 319 subscribers
  • Views 5063 views
  • Users 0 members are here

Add days to date Formula

James West

I have this formula which adds days from Date Field A: addDays($date_a_c,259) . It gives me a date calced off of Date A and puts it to Date Field B. I need a formula which does this, unless Date Field D has a date, in which it should calc from field D.

I cant seem to figure it out. Can I get some pointers to which formula to use there? My rough idea is something like this: addDays($date_a_c, or(addDays($date_d_c,259)) , but of course this doesnt work.

Parents
  • 0

    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

Reply
  • 0

    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

Children