DaysOfFebruary ( myDate )
Gives you then number of days in February the year of myDate
Average rating: 3.9 (44 votes) Log in to vote
|
Gjermund Gusland Thorsen Gudthlandum Consulting http://www.developer.no |
Sample input:
data from any date field
Sample output:
29
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Gives you then number of days in February the year of myDate
Leap year issue
Leapyear issue
Based on the test addressed by: Fabrice Nordmann
Intended use: Choose ( Month( myDate ); 0; 31; DaysOfFebruary( myDate ); 31; 30; 31; 30; 31; 31; 30; 31; 30; 31 )
Comments
 |
David Head, uLearnIT Oct 20, 2009 |
|
| How about doing it this way: Day ( Date ( 3 ; 1 ; Year ( myDate ) ) - 1 ) This gets the day number of the day before March 1 in the specified year. Cheers, David uLearnIT |
||
 |
kade, Hamburg; Germany Oct 27, 2009 |
|
| Why not this way: Day ( Date ( 3 ; 0 ; Year ( myDate ) ) ) |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.