# New template - Asset management **URL:** \ **Category:** News & Announcements\ **Created:** [September 29, 2022, 1:41pm UTC](https://community.fibery.io/t/new-template-asset-management/3344 "2022-09-29T13:41:46Z")\ **Posts on this page:** 11\ **Page:** 1
**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:** [September 29, 2022, 1:41pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/1 "2022-09-29T13:41:46Z")
Here’s a new template to help you if you need to keep track of equipment, software licences or other assets you might have: [https://fibery.io/templates/asset-management](https://fibery.io/templates/asset-management) As always, let us know what you think, tell us your ideas for adapting it, and give us suggestions for templates that you think we might be missing. **UPDATE:** there was a bug in the Due date calculation that existed in the template up until 07/12/2022. If you installed it prior to this date, please see the following: > [@New template - Asset management](https://community.fibery.io/t/new-template-asset-management/3344/10): > > I’ve discovered a bug in the Due date calculation (in the Maintenance Requirement database) open_mouth Not only might it not work if the interval period was greater than 12, it would also not work if the interval was 12 months and the date of the last successful event fell in a December(!) Sorry! Please replace the Due date formula with the following: Date(Year([Date of last (successful) event]) + RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0),(Month([… ---
**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:** [September 29, 2022, 1:42pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/2 "2022-09-29T13:42:18Z")
Pinned on September 29, 2022, 1:42pm UTC ---
**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\ **Post date:** [December 7, 2022, 4:26pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/3 "2022-12-07T16:26:54Z")
I’m giving this template a shot, but I want to create a new Interval for Bi-Annual. Where is the `Interval.Period` being obtained from in the formula for Due date in the Maintenance requirement Database? It appears that the Single Select items have an extra hidden property called Period, but I see no way to add a new one. Thanks! ---
**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:** [December 7, 2022, 4:29pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/4 "2022-12-07T16:29:30Z")
If you hover over a select option and alt-click it, you can see all its properties. ![firefox_IlMXgRrb6q](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/21ed76b3d79be537aef41d4f57168d0ffa3f6ab9.gif) > **[Select Field](https://the.fibery.io/@public/User_Guide/Guide/Select-Field-87)** > > Tailored workspace for your company. Connected databases, customizable views, powerful reports, automations, integrations, docs & whiteboards. If you add an extra option, you can set the value for its period (to 6 in your case). ---
**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\ **Post date:** [December 7, 2022, 4:32pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/5 "2022-12-07T16:32:11Z")
I didn’t even know that existed! Learn something new every day. Thanks! ---
**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\ **Post date:** [December 7, 2022, 4:36pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/6 "2022-12-07T16:36:41Z")
Will this work for Biennial, every 24 months? ---
**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:** [December 7, 2022, 5:14pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/7 "2022-12-07T17:14:18Z")
Any new interval you create can have an integer period of your choice, so yes, biennial would work if you set Period to 24. ---
**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\ **Post date:** [December 7, 2022, 5:31pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/8 "2022-12-07T17:31:41Z")
The Due date doesn’t update if I set it to anything longer than 14 months, it just keeps its last value. ---
**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:** [December 7, 2022, 6:36pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/9 "2022-12-07T18:36:06Z")
Oh dear. Yes, there’s an issue with calculating the Due date for multi-year periods. Let me look into this and figure something out to fix it. ---
**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:** [December 7, 2022, 7:34pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/10 "2022-12-07T19:34:54Z")
I’ve discovered a bug in the Due date calculation (in the Maintenance Requirement database) 😮 Not only might it not work if the interval period was greater than 12, it would also not work if the interval was 12 months and the date of the last successful event fell in a December(!) Sorry! Please replace the Due date formula with the following: `Date(Year([Date of last (successful) event]) + RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0),(Month([Date of last (successful) event]) + Interval.Period) - (12 * RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0)),Least(Day(Date(Year([Date of last (successful) event]) + RoundDown(((Month([Date of last (successful) event]) + Interval.Period) - 1) / 12,0),((Month([Date of last (successful) event]) + Interval.Period) + 1) - (12 * RoundDown((Month([Date of last (successful) event]) + Interval.Period) / 12,0)),1) - Days(1)),Day([Date of last (successful) event])))` This applies to anyone who has already installed it. Sorry for the mistake. Let me know if you encounter any more odd behaviours(!) ---
**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\ **Post date:** [December 7, 2022, 8:54pm UTC](https://community.fibery.io/t/new-template-asset-management/3344/11 "2022-12-07T20:54:29Z")
Worked great! Oh, don’t worry, if it’s a date formula I’d like to leave that to you. 😅