diffForHumans ( ts )

Convert timestamp difference to human readable text

Be the first to rate this function Log in to vote

Ãngel MartÃnez FernÃ¡ndez - Show more from this author
Lesterius Barcelona
https://www.lesterius.es/

Sample input:

diffForHumans ( "6/5/2020 17:18:03" )

Sample output:

//Get ( CurrentTimeStamp ) = 6/5/2020 17:30:42
//Result:
12 minute(s) ago

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

/*
* Purpose: Convert timestamp difference to human readable text
* Autor: Angel Martinez Fernandez, Lesterius Barcelona
* Version:   1.0
*
* Uses: none
*
* Params:
*  -ts : Timestamp
*
* Vars:
*  -diff : Difference in seconds
*  -s : Seconds
*  -m : Minutes
*  -h : Hours
*  -d : Days
*  -w : Weeks
*  -mo : Months
*  -y : Years
*  -lastword: Text to append
*
* Notes:     none
*/
Let (
[
diff = GetAsNumber ( Get ( CurrentTimestamp ) - GetAsTimestamp ( ts ) );
s = Abs( diff );
m = Int ( s / 60 ) ;
h = Int ( m / 60 ) ;
d = Int ( h / 24 ) ;
w = Int ( d / 7 ) ;
mo = Int ( w / 4 ) ;
y = Int ( d / 365 ) ;
lastword = If ( diff < 0 ; "ahead" ; "ago" )
];
Case (
y ≥ 1 ; y & " year(s) ";
mo ≥ 1 ; mo & " month(s) ";
w ≥ 1 ; w & " week(s) ";
d ≥ 1 ; d & " day(s) ";
h ≥ 1 ; h & " hour(s) ";
m ≥ 1 ; m & " minute(s) ";
s & " second(s) "
) & lastword
)

Just as Carbon docs describes it:
It is easier for humans to read "1 month ago" compared to "30 days ago". This is a common function seen in most date libraries so I thought I would add it here as well.

Comments

		TA May 20, 2020
Thanks for the upload, When It is 8 days ago, it still shows 1 week ago. Same thing from 8 to 13 days, All show 1 week ago. I am doing something wrong? I even tried it against a time difference for Date of Birth, the difference can be up to a year.

		Ãngel MartÃnez FernÃ¡ndez, Lesterius Barcelona May 20, 2020
Hello TA, You are doing it right, var â€œdâ€ The difference in days, and in your case â€œ8â€ is being divided by â€œ7â€ inside of var â€œwâ€ being the result â€œ1,1428571429â€, then in the Case() as var â€œwâ€ is greater than 1, it show the â€œ1 week agoâ€. If you want the function to only show the difference up to days. The Case() should be like this: Case ( d â‰¥ 1 ; d & " day(s) "; h â‰¥ 1 ; h & " hour(s) "; m â‰¥ 1 ; m & " minute(s) "; s & " second(s) " )

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

diffForHumans ( ts )

Comments

Support this website.

Support this website.