Brian Dunning's FileMaker Custom Functions

DateRange ( Range )

Creates a searchable date range to populate any date field while in Find Mode

  Be the first to rate this function Log in to vote

Kyle Williams   Kyle Williams - Show more from this author
Dreamclinic Massage

Share on Facebook Share on Twitter

  Sample input:
_DateRange ("Week" )
_DateRange ("Month" )
_DateRange ( 90 )
  Sample output:
1/26/2020...2/1/2020 //Find last whole week (Sun-Sat)
1/1/2020...1/31/2020 //Find last whole month
11/6/2019...2/3/2020 //Find last 90 days

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

When creating Reports a date range is often required. It is always nice to give the user multiple options for their reports. With this function it will automatically return a date range for any given number (up until yesterday) or you can specify you want a date range for last Week, Month or Year.



Log in to post comments.


Note: these functions are not guaranteed or supported by 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 16 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: