Zero to Awesome - Date Range Magic
Working with dates within FileMaker can be a confusing topic if you've not dealt with them before. Knowing how to extract a range of dates complicates this matter further. I remember my first try with mastering dates (especially trying to make a calendar in FileMaker version 3) and it took a few days to get them down, I just couldn't get into the whole "it's all seconds" thing - but eventually I got it.
The great thing about this video is that you'll never need to be confused again. This video, and the accompanying files have almost everything* you might ever need with regards to date ranges.
Whether you're searching in Find mode or simply using a relationship to filter out only the information you need, this file and custom function will provide you with great benefits. No need to reinvent the wheel, it's right here for you to use!
- You'll always need to do some tweaking based on your individual needs and the date/time system according to your locale.