DayOccur ( selDate )

Calculates what Week Occurence and DayName in a month.

Average rating: 4.4 (29 votes) Log in to vote

Don Wieland - Show more from this author
DW Data Concepts
http://www.dwdataconcepts.com

Sample input:

DayOccur ("11/1/2005")
DayOccur ("11/12/2005")
DayOccur ("11/24/2005")
DayOccur ("11/30/2005")

Sample output:

1st Tuesday
2nd Saturday
4th or Last Thursday
5th or Last Wednesday

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

Let([
s=selDate;
t=DayOfWeek(s);
v = DayOfWeek(Date(Month ( s );1;Year ( s )));
w=9 - v;
x=w+7;
y=x+7;
z=y+7;
zz=z+7;
a=Day ( s );
b = Case(a < w; 1; a < x; 2; a < y; 3; a < z; 4; a < zz; 5; 6) - If(t < v; 1; 0);
c = Choose(b; ""; "1st"; "2nd"; "3rd"; "4th"; "5th"; "6th")

];

c & If(Month(Date(Month ( s ); Day ( s ) + 7; Year ( s )))  ≠ Month(s); " or Last"; "")  & " " & DayName ( s )


)

Calculates what Week Occurence and DayName in a month.

Comments

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

DayOccur ( selDate )

Comments

Support this website.

Support this website.