I have a database with a date field called "Received".  By default, my users need only see the last six months of records, only occasionally needing to see beyond that.

 

I can't figure out how to script this find.  I intend to use it in my startup script -- unless there's a better way.  I've Googled it and nothing seems to work as I was hoping.  I am using FileMaker Pro 11 Advanced.

 

Any help would be appreciated.  Thanks!

 

Kevin

I have a database with a date field called "Received".  By default, my users need only see the last six months of records, only occasionally needing to see beyond that.

 

I can't figure out how to script this find. 

 

Try:

 

Go to Layout [ YourTable ]

Enter Find Mode []

Set Field [ YourTable::Received ; ">" & Get ( CurrentDate ) - 180 ]

Perform Find []

 

The 180 days is an approximation, of course. You can calculate the date more accurately by =

 

Let (

today = Get ( CurrentDate )

;

Date ( Month ( today ) - 6 ; Day ( today ) ; Year ( today ) )

)

Thank you, comment, it works like a charm.  It didn't need to be exactly six months, so 180 days works fine.

 

Kevin