Skip to main content
Question

Need help with IF function

  • August 28, 2019
  • 0 replies
  • 20 views
I would like to create an IF function formula for a date field.
Currently I have 'estimated deployment date' field that is always filled in, another field, the 'rollout end date' calculates off the 'estimated deployment date'.
Now, I would like to have an 'actual deployment date' field and IF provided override the 'estimated deployment date' calculation in the rollout date.

my current formula for the 'rollout end date' looks like this: [Expected Deployment Date]+Days(90)

I have no idea how to write this formula, or if it is possible. Any help is much appreciated.

Thank you!

------------------------------
Beth
------------------------------
    This topic has been closed for replies.

    AdamKeever1
    Forum|alt.badge.img+2
    • AdamKeever1
    • Registered
    • August 28, 2019
    Try this Beth:

    If(
IsNull([actual deployment date]),
[Expected Deployment Date]+Days(90),
[actual deployment date])​


    ------------------------------
    Adam Keever
    ------------------------------
    Terms & ConditionsAccessibility statement