Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

Re: Formula help (Start date + number of days)

I suggest that you have one field to calculate the duration in days for display purposes and then use another formula to calculate the end date for the calendar.  The latter will have the minus 1.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

3 Replies

Sort By
  • AlexBennett3's avatar
    AlexBennett3
    Qrew Trainee
    4 years ago
    So I attempted to make new formulas to (-1) for my Calendar alone, and now i'm just running into the same problem except on the calendar. My calendar now wont display anything under 1 day because they result in 0 or -1. is there any changes I can make to the formula to fix this?

    New Formula Ex. Created on Schedules side:
    (ToText(Ceil([7. Sub Duration]/8 -1) & " " & "Days"))

    Duration Code on Calendar side:
    ToNumber(Left(Case([Department - Phase], "Fixtures - Sub Rough", [Schedule - Fixtures Sub Duration(Calendar)], "Fixtures - Rough", [Schedule - Fixtures Rough Duration(Calendar)], "Fixtures - Finish", [Schedule - Fixtures Finish Duration(Calendar)], "Fixtures - Close", [Schedule - Fixtures Close Duration(Calendar)]), " " ))

    ------------------------------
    Alex Bennett
    ------------------------------
    • AlexBennett3's avatar
      AlexBennett3
      Qrew Trainee
      4 years ago
      Is there a way to convert a Date field to Workdate? I'm attempting the WeekdayAdd function, but my start date is just the field type date. On the formulas page it says it can be used with Workdate as well? This sounds like my issue as having WeekdayAdd(WorkDate d, Number n) Sounds like it will include the start date as the duration. As WeekdayAdd(Date d, Number n) which I'm currently using, does not. I'm just not sure how to change the type to Workdate in my start date fields. Maybe Formula - Date, and add a certain formula to do so?

      ------------------------------
      Alex Bennett
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        4 years ago
        Nevermind, found the problem in my process and made some changes to different layers of code.

        Thanks Mark.

        ------------------------------
        Alex Bennett
        ------------------------------