Search Projects by Month

[Nikos Gewrgioy]

Hello,

I am new in filemaker. 

I have make a database to save some guitars informations and I would like to search how many guitars I have saved in January, February etc...

At this time if I search between 1/1/2013 - 1/31/2013 then Filemaker told me: No records match this find criteria but I have saved 8 guitars at January 2013.

How can I solve this problem?

 

 

I have uploaded my database to dropbox if you want to see the problem

https://www.dropbox.com/s/fo6f8qcbfq0b1e4/Projects.fmp12.

 

Sorry for my English, it's no good.

Thank you in advance

[Ron Cates]

1/1/2013 - 1/31/2013

should be

1/1/2013...1/31/2013

[Nikos Gewrgioy]

I don't put the hphen, I have two different fields, one for arrival date and one for finishing date.

I press the find mode button and then check the dates 1/1/2013 on the arrival date field and 1/31/2013 on the finishing date and then I press the Perform Find button.

[Ron Cates]

By doing the find that way you are asking for all records where the arrival date is 1/1/2013 and the finishing date is 1/31/2013. It does not do a range. You could put 1/1/2013...1/31/2013 in the arrival date field and that will give you all guitars that arrived within those dates. Or you can put it in the finished date field and that will give you all the guitars finished between those dates. If you want a found set of records that either arrived or were finished between those dates you can enter

 

>=1/1/2013 in arrival date

and

<=1/31/2013 in finished date

 

This will give you all guitars that either arrived in January or were finished in January.

[Ron Cates]

Correction

 

>=1/1/2013 in arrival date

<=1/31/2013 in finished date

 

This will give you all guitars that arrived in January AND were finished in January.

 

To get all that Arrived in January OR were finished in January, you would have to make two requests.

 

>=1/1/2013 in arrival date

New Record/Request

<=1/31/2013 in finished date

Perform Find

[Nikos Gewrgioy]

Thank you very much Ron Gates.

 

It works. Yeah

 

 

You are the best.