DaysInMonth ( text )

Calculates the number of days in a chosen month

Average rating: 4.5 (11 votes) Log in to vote

Neil Manchester - Show more from this author
NDMW

Sample input:

DaysInMonth ( 16/02/2016 )

Sample output:

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

Let ( [

	$year = Year ( text ) ;
	$leap = If ( $year / 4 = Int ( $year / 4 ) ; "Yes" ; "No" ) ;
	$month = Month ( text )

] ; 

	Case (
		$month = 1 ; 31 ;
		$month = 2 and $leap = "No" ; 28 ;
		$month = 2 and $leap = "Yes" ; 29 ;
		$month = 3 ; 31 ;
		$month = 4 ; 30 ;
		$month = 5 ; 31 ;
		$month = 6 ; 30 ;
		$month = 7 ; 31 ;
		$month = 8 ; 31 ;
		$month = 9 ; 30 ;
		$month = 10 ; 31 ;
		$month = 11 ; 30 ;
		$month = 12 ; 31 ;
	) 

)

This is a simple CF that returns the number of days in a given month taking into account leap years.

Comments

		comment, VR Aug 21, 2016
First, your calculation of leap years is incorrect. You will get a wrong result for the month of February 2100, for example. Next, you should not prefix your variables with $, because these hang around until the end of the session - and they might interfere when the function is called again. Finally, the number of days in a given month can be calculated much more simply as: Day ( Date ( Month ( GivenDate ) + 1 ; 0 ; Year ( GivenDate ) ) )

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

DaysInMonth ( text )

Comments

Support this website.

Support this website.