Search by day, week or month

[Sam Laundon]

I am new at using the scripting functions and calculations and am having problems trying to figure out how to create the calculations for a pop up window on the search page that will allow doing a search on all records created "today" and "the last week" and "the last month". I can create the pop up window, but do not know how to create the scripts for the above 3 time periods. If someone could reply with to this with the scripts, I would be very grateful.

Thanks in advance for your help - Sam

--

[Keith M. Davie]

To find out more about the problems of ScriptMaker on the web, visit my site.

You will find the cdml reference database useful.

Remember that you are trying to get your format file to talk with your db file.

USE THIS RESOURCE OFTEN.

http://www.filemaker.com/support/index.html

________________________________________________________

Search and read: Article Number: 104829, and Article Number: 105687

________________________________________________________

Understanding the use of the symbols of an exact search in a cdml solution will enable you to understand how to use in your cdml solutions all the symbols available in the FMPro db find operation (see db status bar).

See also these useful threads in the cdml forum for examples and other approaches/ideas:

[Jeff Spall]

Hi,

I think that you want to do is best achieved over the web if you use calculation fields in the database to define this week, this month etc which set flags and then search on them.

The major drawback with any current date function is that because the date is a moving target, you can't store/index the results, so performance can suffer.

This might help, it's something I'm working on right now; an events calendar which shows 'this week', the next four weeks' or month - by month. Today can simply be a search on the date field with the 'today' function (that's %2f%2f as part of an html search string, but plain // in an inline action)

The file includes the pages, the databases and some search strings. I hope it might give you a better idea than if I try to explain!

Click the 'attachment' link at the top of this post to download the file.

[Sam Laundon]

Thanks for the info I will explore the attached database and cdml files.

Sam