Find: All dates in May, 2004FMP 7: 1/5/2004…31/5/2004
FMP 8+: 5/2004
—
Find: July 1997 thru October 1998FMP 7: 1/7/97…31/10/98FMP 8+: 7/1997…10/1998
—
Find: All timestamps occurring in the 3 o’clock hour today
FMP 7: must specify manually
FMP 8+: // 3 pm
—
Find: All times occurring in the 3 o’clock hour (not including 4:00 pm)
FMP 7: 3:00 pm…3:59:59.999999 pm
FMP 8+: 3 pm
—
Find: All dates that occur on a Friday
FMP 7: not possible
FMP 8+: =Friday
—
Find: All timestamps in the 3 o’clock hour, in the month of May, 2005
FMP 7: not possible
FMP 8+: 5/2005 3 pm
—
Find: Add dates in the year 2004, but only if their day is the 10th thru the 15th
FMP 7: not possible
FMP 8+: {10..15}/*/2004

Paul de Hallé
Paul de Hallé is the CEO and founder of Linear Blue, having set up the company in 1999 to focus on intuitive database solutions and web integration. Paul is a FileMaker Certified developer; and has also been a key player in the implementation of the FileMaker Certification program since it's inception with FileMaker 7. A regular guest speaker at FileMaker Business Alliance & Technet meetings in the UK and the FileMaker Developers Conference in the USA, along with contributing to various technical publications around the world.