Brian Dunning's FileMaker Custom Functions

MonthYearList ( StartDate ; EndDate ; display )

Month Year List from date range (start and end date)

  Be the first to rate this function Log in to vote

Alex Bassin   Alex Bassin - Show more from this author
SYNAP
http://www.synap.net

Share on Facebook Share on Twitter

  Sample input:
MonthYearList ( "1/2/2018"; 5/5/2019; 3 )
  Sample output:
1/2018
2/2018
3/2018
4/2018
5/2018
6/2018
7/2018
8/2018
9/2018
10/2018
11/2018
12/2018
1/2019
2/2019
3/2019
4/2019

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

- returns a return-delimited list of month and years starting based on a date range
Parameters
- short: 1= Full month name, 2= short month name, 3= number of month / year, 4=as date (first of the month)
Credit: Alex Bassin, SYNAP Corporation - www.synap.net
Special thanks to David Head who build the original

 

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: