topic Averaging dates in App Development

Averaging dates

Anonymous — Fri, 23 Dec 2022 14:15:42 GMT

Greetings,

Is there a way to formulate out a way to find that average date from a list of dates based on topic? For example, I want to look at all of the components that deal with system A and see what the average date of expiration is for those components? That way I can tell my customer that they need to start getting replacements before a specific date.

Thank you in advance.

Re: Averaging dates

Rick2Foqus — Fri, 23 Dec 2022 15:06:00 GMT

Every date behaves like a number on the background. The numbers before the comma correspond with the date, the numbers after the comma with the time. You need to make a number of the date first by using: NUM(Date).

If you take the average, there will probably be some numbers behind the comma. You can remove those by the function "FLOOR".

The final function you could use is:

Date(FLOOR(AVG(NUM(DATE))))