AnsweredAssumed Answered

How to display a date calculation globally on hosted database?

Question asked by DanielPinder on Jan 30, 2011
Latest reply on Jan 31, 2011 by Sorbsbuster

Title

How to display a date calculation globally on hosted database?

Post

Many thanks in advance.

I am trying to make a system to calculate how many minutes per day need to be written (by a composer) based on a date of completion and today's date. In other words, say the date the project needs to be done by is May 1st and there are 90 minutes left to write. I already have a field that calculates minutes yet to be written ("Total_unwritten") but I need the new component to calculate the current value of Total_unwritten divided by the amount of days existing between today and the completion date and express it in minutes.

I think I managed to do the calculation correctly:

days_left = (date_of_completion - Get(CurrentDate))

minutes_per_day = (Total_Unwritten  /  days_left)

So my question is, how do I make this a global value in a hosted database? I want to display it in the header and have it not tied to only one record.

THANKS

Outcomes