Brian Dunning's FileMaker Custom Functions

ListWeekDays

List of the weekdays in date format

  Be the first to rate this function Log in to vote

João Coutinho   João Coutinho - Show more from this author
http://www.joaocoutinho.net

Share on Facebook Share on Twitter

  Sample input:
ListWeekDays ( 05 ; 2019 )
  Sample output:
01/05/2019
02/05/2019
03/05/2019
06/05/2019
07/05/2019
08/05/2019
09/05/2019
10/05/2019
13/05/2019
14/05/2019
15/05/2019
16/05/2019
17/05/2019
20/05/2019
21/05/2019
22/05/2019
23/05/2019
24/05/2019
27/05/2019
28/05/2019
29/05/2019
30/05/2019
31/05/2019

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

//

Creation Date: 2019 06 03
Function: List of the weekdays in date format
Autor: João Coutinho
URL: www.joaocoutinho.net

//

While (


[

$Month = DateMonth ;
$Year = DateYear ;
Days = Date ( $Month ; 1 ; $Year );
WeekDays = ""

];


Days < Date ( $Month+1 ; 1 ; $Year );


[
WeekDays = WeekDays & "" & If ( DayOfWeek ( Days ) ≠ 1 and DayOfWeek ( Days ) ≠ 7 ; Days & "¶"; "" );
Days = Days + 1
];

WeekDays

)

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: