Hi, I have a script that shows records by month and by day, but I want to filter this findset to show the days after 20 day of a month (example 11 - november) and the days before 20 of the next month (example 12 - december).

Someone can help me?

Thank you so much.

If I understand you correctly, just put the dates into a search field like this.

11/20/2005...12/20/2005

And it should give you everything between those two dates.

Yeah, it is something like that, but I need a script that makes that...

My script have something like this:

Script name: Find

Enter Find Mode[]

Set Field[TEST::Month; TEST::Find_Month]

Set Field[TEST::Day]

Perform Find[]

In Line 3 (Set Field[TEST::Day]), I need to specify a calculated result that shows the date between 20 in a month and 20 in the next month.

I don't know how to do this, but I think that I have to modify the second (Set Field[TEST::Month; TEST::Find_Month]) and the third (Set Field[TEST::Day]) lines.

If you know something to do this, please tell me.

Thanks.

Hi

if you have a field MyDate with a real date inside, you can try:

Enter Find Mode[]

Set Field[TEST::MyDate;"11/20/2005...12/20/2005"]

Perform Find[]

This will find all the records with those date inside the field MyDate.

Naturally this kind of script isn't so good, because we have hard-coded the range.

It will be better to make a new field (InsertRange), where we can type our search range.

The script will became:

Enter Find Mode[]

Set Field[TEST::MyDate;TEST::InsertRange]

Perform Find[]