AppColl Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Groups

    Date Calculations

    Product Requests
    2
    2
    135
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • KimG5166
      KimG5166 last edited by

      I would love to see the ability to do a datediff or add or subtract a date from "now" in the reporting module. To be able to see the actual number of days between OpenedOn and Today, would be super helpful. We have many clients that ask for that status metric.

      JonahP1621 1 Reply Last reply Reply Quote 1
      • JonahP1621
        JonahP1621 @KimG5166 last edited by

        @KimG5166 I like the idea. I would find it very useful. My first thought was that it would be a big project/change for the AppColl team.

        However, on a second thought, it might not be very difficult to implement. The Account Settings allow custom fields of type TextBox, DropDown, or MultiSelect. MultiSelect allows a database query for a source of values. The database query must be a Boolean expression.

        Perhaps AppColl could implement another type of custom field with a name such as DatabaseQuery. It would allow the user to enter any valid database query. It could, for example, allow IssueDate-FilingDate (which would tell you how long an application was pending).

        I hope that they implement the request for matters soon.

        I believe that your request for Today-OpendOn is for tasks database queries, not matter database queries. That would require that AppColl first enable custom fields for Tasks like they have for Matters. That probably deserves a different product request.

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        0
        Online

        551
        Users

        336
        Topics

        967
        Posts