Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Testing for Number of Weeks

I have a numeric field 'weeks' I have used to work out number of weeks between two dates.  Works fine. I am then using following statements in a formula text field to allocate certain text values.   b...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
What�s the symptom of the problem.

Also if Weeks calculates to a number near you break point such as 54.5, your formula is not catching that.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    8 years ago
    I missed Mark's point. Maybe update as follows:
    var Number NumWeeks = ToNumber([Weeks]);
    If([Project Type] = "New",
      If(
        55 <= $NumWeeks and $NumWeeks < 68, "Phase 1",
        41 <= $NumWeeks and $NumWeeks < 55, "Phase 2",
        27 <= $NumWeeks and $NumWeeks < 41, "Phase 3",
        13 <= $NumWeeks and $NumWeeks < 27, "Phase 4",
         1 <= $NumWeeks and $NumWeeks < 13, "Phase 5",
        "Phase 6"
      ) )