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
About Paul de Hallé
Paul de Hallé is the founder and Development Director of Linear Blue, having set up the company in 2000 to focus on intuitive database solutions and web integration. Paul is a FileMaker Certified developer on versions 7 to 11; 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 Paul is also a contributor to Advisor magazine, the leading industry Database publication.
