Today in a formula

Follow

Comments

7 comments

  • Avatar
    David Rice

    Hi -


    Unfortunately, you cannot use (Today) in a formula definition. The story is captured in the backlog but I am not sure when the feature might be built.


    In the meantime, you have a few options:



    • If there is a particular age you want to reporting against, say 14 days, you could create a property around that, say ‘Overdue On’ and it’s set to “Created On” + 14. You could then compare “Overdue On” to (Today) in MQL criteria for reports or in the cards filters.

    • Write a simple script (Ruby using ActiveResource is by far the easiest) that runs once a day and re-calculates the age using the API. You would setup an ‘Age’ property as a standard date property. The script would set it to (Today) – whatever date property you wanted to use (“Created”, “Opened”, “Started”). If you have a developer with a few spare minutes this is likely the most useful solution.

  • Avatar
    Colin Campbell

    David,


    Thanks for your response. I actually am a developer and that sounds like a really easy script to write. However, where do I need to run this at? Right now we’ve got mingle running on a Mac Mini and when I go into the Mingle directory there’s just public and config. Have I installed it incorrectly or am I looking in the wrong place?


    Thanks,


    Colin

  • Avatar
    David Rice

    Hi -


    There is no location in which you would install the script (although a folder or nightly scripts is a decent feature idea). You would place the script anywhere you wanted and run it via cron or some other scheduler at the desired intervals. You might create a folder called ‘scripts’ in your mingle data directory.

  • Avatar
    Ariel

    I need to use "Today" in a formula property. Is this feature still on the backlog?


    I need to do something like this: TODAY - 'Ready for testing on'


    I just want to display the number of days the story has been opened before being accepted


    Thanks,


    Ariel.

  • Avatar
    Suzie Prince

    Ariel


    This is still in the backlog.


    Before we add your request to this I'd like to confirm that you expect the value for this property to change everyday, don't you? This is because TODAY is different every day. If this is not what you expect please let us know in more detail what you do expect.


    Thanks


    - Suzie

  • Avatar
    Ariel

    Hi Suzie. yes that´s what I need. TODAY should be different every day.


    We need to do this calculation because the red section of the chart needs to be increased one unit per day until the story is accepted



    Thank you,


    Ariel.

  • Avatar
    Suzie Prince

    Thanks Ariel.

Please sign in to leave a comment.