Brian Dunning's FileMaker Custom Functions

ElapsedTimeInWords ( aTimeStamp )

Calculates time elapsed since TimeStamp in words

  Average rating: 4.3 (28 votes) Log in to vote

Jason Ball   Jason Ball
Streamtime Software

Share on Facebook Share on Twitter

  Sample input:
ElapsedTimeInWords ( 31/12/2000 12:00:00 am )
  Sample output:
2 hours ago
6 days ago
about 1 month ago
about 1 year ago
almost 2 years ago
3 years ago

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

Calculates (in words) time elapsed since a timestamp much like you'd see in a Facebook / Twitter feed....



João Coutinho   João Coutinho
Jan 25, 2018
Great work. Love this for our Chat System.

Log in to post comments.


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

Under construction. Email me your wish list for improvements.