Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating Difference Between Two Dates using Multiple If statements

I have another multiple "if statement" that I'm having issues with.    PKG.1_DATE1 =1/1/2020 PKG.1_DATE2 = 1/14/2020  PKG.2_DATE1 = 1/2/2020 PKG.2_DATE2 = 1/20/2020    This worked Custom Colu...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Is the second custom column referencing the first one?  Maybe just a typo in the post, but the names are different (Latest Package Date vs. Latest Package Delay).

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    mahoneypat 

    No, it should be Latest Package Date. This is not a problem. I need to find the difference in weeks from the latest package date.