PostPer_Day ( Post ; startDate ; finishDate ; returnType )

Post Per Day

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

Robert Schaub
n/a
n/a

Sample input:

Posts_PerDay (5001 ; "3/15/2004" ;Get ( CurrentDate ); "d")

Sample output:

2.134

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

 /* 
//PostPer_Day ( Post; startDate ; finishDate ; returnType )

PostPer_Day

Post
startDate
finishDate
returnType
*/

Posts / 
Let(

[

availableDates = Case ( 

not IsEmpty(startDate) and IsValid(startDate) and not IsEmpty (finishDate) and IsValid(finishDate) ; "both" ;

not IsEmpty(startDate) and IsValid(startDate) and IsEmpty (finishDate) ; "start" ; "none" ) ;



days = Case (

availableDates = "both" ; GetAsDate(finishDate) - GetAsDate(startDate) ;

availableDates = "start" ; Get(CurrentDate) - GetAsDate(startDate ) ) ;

months = Round ( days/30 ; 0 ) ;

years = Round ( days/365.25 ; 0 )

]

;


Case (

returnType = "d" ; days ; 

returnType = "m" ; months ; 

returnType = "y" ; years )


)

/* Calculate the number of days "d", months "m" or years "y" between two dates

With the help of on of Michael Richards functions*/

Get post per day for any user any forum.
Enter number of post, a stsrt and finish date and 'd' for return type.

Comments

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

PostPer_Day ( Post ; startDate ; finishDate ; returnType )

Comments

Support this website.

Support this website.