Search Dates Between

[Ben Ball]

I need to search for a set records between month names. i.e I wish to find records from January 2007 to March 2007.

Any ideas how I can do this?

[Ocean West]

search the forums we just covered that a few days ago... Also this can be found in your FileMaker help file.

http://fmforums.com/forum/showtopic.php?tid/187169/

[Genx]

Not for month names :

[Lee Smith]

look at the Online Help for [color:blue]Finding ranges of information and it gives this example..??

1/2007...3/2007

It returns the dates of January 1, 2007 through March 31, 2007

Lee

[Genx]

Thats certainly intriguing.

Its definitely a departure from the usual mm/dd/yyyy logic.

[sbg2]

Is that specific to certain version(s) of Filemaker? When I try this with version 7 it creates a validation error. "The value of this field must be a valid date in the range of years 1 to 4000...".

[Lee Smith]

It was new to v8.

Lee