Find all records with date = tuesday

[rob1234]

I have a date field in my database that has dates corresponding to pretty much every tues, wed, thur, and fri of the last couple of years.

What I want to do is export all the records where the date field equals a day that was a tuesday between june 2005 and june 2006.

Is there an easy find I can do to just get these days? Any suggestions? This is a Filemaker 5.5 database.

[Lee Smith]

Create a new calculation field and use the Day Name Date Function

DayName(YourDateField)

Now you can search for the name like Monday

HTH

Lee

[Ender]

Add a calc:

DayName (calculation, text result) = dayname(Date)

Then do a find with two fields: DayName = Tuesday and Date = 6/1/05..6/30/06

Then export the found set.

[rob1234]

Great. Thanks for the replies.