YAMA ( dat ; n )

Yet Another Month Add

Be the first to rate this function Log in to vote

Erich Schmidt - Show more from this author

Sample input:

YAMA ( "31.12.2018" ; 2 )

Sample output:

28.2.2019

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

// YAMA(dat;n)        Yet Another Month Add
// Erich Schmidt 12.02.2019
// Parms: dat    -     a date
//        n      -     a number of months    (positive or negative integer)
// return  :           the date  n months ago (n negative) or  n months later (n positive)      

Let(
[ 
    d = Day(dat);
    z = 12*Year(dat) + Month(dat) - 1 + n;
    m = Mod(z;12);
    y = Div(z;12);     
    mtab = Choose(m;31;If( Mod(y;4);28;If(Mod(y;400);If(Mod(y;100);29;28);29)) ; 31;30;31;30;31;31;30;31;30;31)  
];
Date ( m+1;Min(mtab;d);y)
)

The function returns the date n months ago (if n is a negative integer) or n months later (if n is a positive integer).

Comments

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

YAMA ( dat ; n )

Comments

Support this website.

Support this website.