# Formula to get the time a status has changed - status history **URL:** \ **Category:** Ideas & Features\ **Created:** [February 8, 2023, 1:31pm UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943 "2023-02-08T13:31:42Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Michel\_Daviot](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michel_daviot/32/6094_2.png) [@Michel\_Daviot](https://community.fibery.io/u/Michel_Daviot)\ **Post date:** [February 8, 2023, 1:31pm UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/1 "2023-02-08T13:31:42Z")
Continuing the discussion from [Time in status for field, or "field modification date"](https://community.fibery.io/t/time-in-status-for-field-or-field-modification-date/1181/7): I’m not sure if this is the same need or another … I need to track important dates on our product features, like release date. I’m looking for a way to get the last time the status was changed to “production” in a formula. Current workaround : automation to update a “production date” field. Drawback : it cannot be computed afterwards for another status. I guess the information is already stored somewhere in fibery because it is used to build [CFD](https://the.fibery.io/@public/User_Guide/Start-6568#Guide/Cumulative-reports-59) like reports. ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [February 11, 2023, 1:02pm UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/2 "2023-02-11T13:02:10Z")
Hi! Indeed there is no way to handle that except through reports and automations. CFD uses a specific technology that tracks that, but to implement that on the formula level, we need additional development And could you please share, how would you use this info? Because at the moment, our historical reports may be also visualized in a Table, [like here](https://the.fibery.io/@public/User_Guide/Guide/Cumulative-report-track-changes-made-by-Author-112). So I wonder maybe can work as a workaround for you? ---
**Author:** ![Michel\_Daviot](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michel_daviot/32/6094_2.png) [@Michel\_Daviot](https://community.fibery.io/u/Michel_Daviot)\ **Post date:** [February 13, 2023, 3:35pm UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/3 "2023-02-13T15:35:05Z")
Hi, thanks for your reply. I gave a try to the table visualization in historical report but I did not manage to fit my need. I’d like to add metrics on each task with the time spend in status, so that I can identify tasks which spent a lot of time in these statuses. For instance, I’d like to identify which tasks spent the most time in “to review” status in the past month. If the “modification date” and “modification valid to” were available in a formula, I would simply compute the difference and get the time spent in each status. My current workaround is to add a field + automation for each of the status to record the date at which the status changes. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [February 13, 2023, 4:35pm UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/4 "2023-02-13T16:35:58Z")
For historical reports, there are a couple of fields - Duration (Hours) and Duration (Days) - that give you the time spent between modifications. ---
**Author:** ![Michel\_Daviot](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michel_daviot/32/6094_2.png) [@Michel\_Daviot](https://community.fibery.io/u/Michel_Daviot)\ **Post date:** [February 14, 2023, 9:38am UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/5 "2023-02-14T09:38:05Z")
Thanks ! That did the job 🙂 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3443550e4c5f313a52790d25b104600a859cfc9f.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 29, 2025, 11:19am UTC](https://community.fibery.io/t/formula-to-get-the-time-a-status-has-changed-status-history/3943/6 "2025-04-29T11:19:51Z")