DateRangePast ( )

Function stats

Average user rating
295
311
9999
Support
FileMaker 7.0 +
Date posted
21 May 2011
Version
1
Recursive function
No

Author Info
 Atalanta

2 functions

Average Rating None

author_avatar



 

Function overview

Prototype

DateRangePast  ( refdate;   mos )


Parameters

refdate  the base date from which you're measuring


mos  how many months back to go


Description

Tags:  Date  

This is to get a range of dates begining with the first of the month, x mos in the past through the last day of the previous month. The refdate must be a valid date and the mos must be a valid number.

Examples

Sample input

DateRangePast(get(currentdate) ; 6)


Sample output

11/1/2010...4/30/2011 (when the current date is 05/05/2011 and you want to look at the past 6 months)

 

Function code

Date ( (Month(refdate)-mos); 1; Year(refdate)) & "..." & Date ( (Month(refdate)); 0 ; Year(refdate))

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

    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/311

    Prototype: DateRangePast( refdate; mos )
    Function Author: Atalanta (http://www.fmfunctions.com/mid/295)
    Last updated: 21 May 2011
    Version: 1

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

 

 

 

 

 

 

 

Top Tags

Text Parsing  (31)
Date  (26)
List  (26)
Format  (23)
XML  (22)
Sql  (18)
Dev  (18)
Debug  (15)
Interface  (13)
Text  (13)
Layout  (12)
Variables  (12)
Filter  (10)
Design  (10)
Layout Objects  (8)
Timestamp  (7)