Brian Dunning's FileMaker Custom Functions

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   Daniel Wood - Show more from this author
Digital Fusion Ltd

Share on Facebook Share on Twitter

  Sample input:
DateAgeDisplay ( Get ( CurrentTimeStamp ) - 30 )
  Sample output:
30 seconds

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

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.


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.



Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: