none
project server 2013 task level custom fields formula RRS feed

  • Question

  • Let's assume below column values: [Baseline Finish]="06/15/2016" [Baseline Work]=47 Hrs.

    I'm new to SharePoint and don't have much idea about formula, Please Can anybody help me to understand below custom fields formula and what will be the output of it?

    IIf([Baseline Finish] < ProjDateAdd (Date(), Str(8 - IIf(Weekday(Date()) > 1, Weekday(Date()), 8))) Or CDate(ProjDateConv([Baseline Finish], pjdate_mm_dd_yyyy)) = ProjDateAdd(Date(), Str(8 - IIf(Weekday(Date()) > 1, Weekday(Date()), 8))), [Baseline Work] / 60, 0)

    I would like to know what date will be populated by below formula

    ProjDateAdd (Date(), Str(8 - IIf(Weekday(Date()) > 1, Weekday(Date()), 8))) Or CDate(ProjDateConv([Baseline Finish], pjdate_mm_dd_yyyy)) = ProjDateAdd(Date(), Str(8 - IIf(Weekday(Date()) > 1, Weekday(Date()), 8)))

    Monday, June 13, 2016 5:57 AM