FirstOfMonth ( )

Function stats

Average user rating
2.2857
52
116
9999
Support
FileMaker 7.0 +
Date posted
05 December 2008
Version
1
Recursive function
No

Author Info
 uLearnIT

7 functions

Average Rating 2.7

author_avatar



 

Function overview

Prototype

FirstOfMonth  ( date )


Parameters

date  any calendar date


Description

Tags:  Date  

Returns the date of the first day in the month of the given date

Examples

Sample input

FirstOfMonth ( Date ( 12; 25; 2008 )


Sample output

1/12/2008 (international format) or 12/1/2008 (US format)

 

Function code

/*
FirstOfMonth ( date )
Purpose: Returns the date of the first day in the month of the given date
Author: David Head, uLearnIT
*/

Date( Month ( date ); 1; Year ( date ) )


// ===================================
/*

    This function is published on FileMaker Custom Functions
    to check for updates and provide feedback and bug reports
    please visit http://www.fmfunctions.com/fid/116

    Prototype: FirstOfMonth( date )
    Function Author: uLearnIT (http://www.fmfunctions.com/mid/52)
    Last updated: 05 December 2008
    Version: 1

*/
// ===================================

 

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (31)
Date  (28)
XML  (26)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)
Interface  (15)
Layout  (15)
Text  (14)
Variables  (12)
Layout Objects  (11)
Filter  (11)
Design  (10)
Array  (7)