Date Range search and post count
I am new to FileMaker and DB in general... I am trying to get the following data to show in the following way...
I have a field where I have a History of dates and times: (example)
3/5/2011- 6:21:09 PM
What I want is to have a different field (example: MoCntMar) which should count the lines that have fall within the month of March, and then display that count in this field. (in this example would be 5)
I have tried a few things such as "IF" command but have not been able to get it to work...
Any help will be really appreciated!