locked
How to build a "Case" RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I need to build a "case style" Calculated_date based on a field that contains a list of values (Frequency). 
    Like:
    IF "Frequency" is "Annual" then Calculated_Date = Initial_date + 1 year (or +365 days)
    IF "Frequency" is "Monthly" then Calculated_Date = Initial_date + 1 month (or +30 days)
    IF "Frequency" is "Daily" then Calculated_Date  Initial_date + 1 day.

    How can I do that ?

    Thanks for your help! 


    Wednesday, January 25, 2017 7:44 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Josee,

    We can create a calculated field with formula like below to calculate the date based on the Frequency field value:

    =IF(Frequency="Annual",Initial_date+365,IF(Frequency="Monthly",Initial_date+30,IF(Frequency="Daily",Initial_date+1)


    Thanks

    Best Regards

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, January 26, 2017 6:42 AM