Quick Base Discussions

Expand all | Collapse all

How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

  • 1.  How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-09-2017 19:45


  • 2.  RE: How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-09-2017 19:49
    Not only do I need to see from "Date Created" to "Date Completed", but would also like to see "Date Created" to Todays Date if not completed.


  • 3.  RE: How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-09-2017 19:54
    Try this as a formula numeric field called [Project Duration Days]

    var date EndDate = IF(not IsNull([Date Completed]),[Date Completed],Today());

    ToDays($EndDate - ToDate([Date Created]))

    The built in field for [Date Created] is actually a date/time field type so that is why it needs to be converted to a date with the ToDate function.


  • 4.  RE: How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-11-2017 14:36
    Another question if I may.
    In a message from quickbase, I want to put a link to the original message in the email.
    I know that the link is created using:  %recLink%

    However, is it possible to put this in a href tag?
    <a href="%recLink%">REPLY to this message</a>

    It is not displaying properly in my test


  • 5.  RE: How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-11-2017 14:41
    I suggest that you build you own link.

    Here is an example.

    I always do them this way as that way the syntax is always correct the first time.

    var text Words = [Account Name];
    var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];

    "<a href="  & $URL & ">" & $Words & "</a>


  • 6.  RE: How can I calculate the duration of a project to display in a table? I have a field ""Date Created"".

    Posted 05-09-2017 20:28
    Worked Perfectly!!!   Thank you so much!!