Script to find all PO's received in current month
I have a database that tracks customer projects. I have a field called PO Date that is the date the PO was received for that project. I want to create a script that when activated will find all records that have a date in the current month for the PO Date field. In other words, script that will return all PO's that have been received in the current month.
I have been doing this manually, ( 12/1/14...12/31/14 ) but having script that I could attached to a button would be nice.
What is the most efficient way to do this?
Any help here would be greatly appreciated.
I have FMPro Advanced 13.0 v4
OS - Windows 7