Here is the situation:
I work in a school. We are trying to create a database to store our daily announcement list. Each record has a start date fiedl and an end date field. We would like to write a script that will select a group of records examining each record to see if the current date falls between the start date and end date values. Once it has selected the group of records, we want it to switch to a different layout and display the records.
Here is the one sticky point: The database will be hosted on a Filemaker Server, and the documentation we have found so far, says that in order for it to get the current date, the database must be closed and then re-opened each day AT THE SERVER. Obviously, this isn't going to work.
Anyone have any ideas?
BTW - We eventually will be using this database with Lasso and our webserver to accomplish a web version of this also.
Thanks for your help!