Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

DateAgeDisplay ( aTimeStamp )

Display the age of a timestamp in a facebook-style display in either seconds/minutes/hours/days

  Average rating: 4.6 (31 votes) Log in to vote

Daniel Wood - Show more from this author Digital Fusion Ltd http://www.teamdf.com

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* Purpose: To display the age of something in a seconds/minutes/hours/days format. This is a similar format to used on a number of websites now, ie facebook Example: 6 seconds / 8 minutes / 14 hours / 1 day Assumptions: Rounds off to the nearest unit. Assumptions: Once maximum unit reached, automatically ticks over to next (ie 61 minutes = 1 hour, 61 seconds = 1 minute, 25 hours = 1 day ) Created by: Daniel Wood, Digital Fusion Ltd, 14/3/2009 */ Let ( [ Difference = GetAsNumber ( Abs ( Get ( CurrentTimeStamp ) - aTimestamp ) ) ; SetVariables = Case ( Difference ≤ 60 ; Let ([ $unit = "second" ; $amount = Difference ]; "" ) ; Difference ≤ 3600 ; Let ([$unit = "minute" ; $amount = Round ( Difference / 60 ; 0 ) ]; "" ) ; Difference ≤ 86400 ; Let ([$unit = "hour" ; $amount = Round ( Difference / 3600 ; 0 ) ]; "" ) ; Let ([ $unit = "day" ; $amount = Round ( Difference / 86400 ; 0 ) ]; "" ) ) ]; $amount & " " & $unit & If ( $amount ≠ 1 ; "s" ; "" ) ) Click to copy

This function will display a condensed version of the age of a timestamp suitable for when you don't need to know the exact age. It will display the age in one of four formats: seconds / minutes / hours / days. Only one of the four formats is used depending on the age of the timestamp.

Examples:

1 second
35 minutes
6 hours
2 days ....

Handy if you use concepts like tasks, messages, notifications, alerts in your database, it quickly lets users see how old something is without bombarding them with confusing dates and timestamps.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: