FileMaker Pro Custom Functions

There is no need to use $variables and there is a possible conflict with script variables. The function works just as well by removing all the "$" characters.

Bruce Robertson, Redmond
July 17, 2010 10:38am

Like this:
Let ([
d = theDate;
m = Month(d);
y = Year(d)
];

Case(
m > 9 ; Date (10;1;y);
m > 6 ; Date (7;1;y);
m > 3 ; Date (4;1;y);
Date(1;1;y)
)
)

Bruce Robertson, Redmond
July 17, 2010 10:42am

Try =

Date ( 3 * Div ( Month ( date ) - 1 ; 3 ) + 1 ; 1 ; Year ( date ) )

comment, VR
July 19, 2010 12:39am

Nice, a much more concise statement. I wanted to write that but didn't have the time to play with the math. Thx for feedback.

Chiyoko Yoshida, Chicago IL
July 19, 2010 7:57am