Hello,

I am sure this is easy but i just can't think of it... how would i make a dynamic script that could peform a find with the range of 30 days between the current date and today? I can hard code it by going to find mode, but i wanted to make it easy as pressing a button to specify criteria and always do it within that range.

v

Ummm, why are you using find? If you have a normalized design you should be using relations.

What do you mean by "range of 30 days between the current date and today"?

It can be done easily, just need to know exactly what you mean.

I have a date field and a drop down box to tag an entry with a "type", say for instance,... "red", "blue", and "green". For every entry there is a type selected... there are hundreds of entries a day and I want the user to be able to press one button and find all "blue" entries in the last 30 days. Why would this be a normalization/relation issue? Each entry is basically flat filed with a date field and this type field...??

It's easy to manually do a Find and do it by range x/x/xx .... x/x/xx but I don't want to make them type it in all the time. How do I basically make a calculation that says take today's current date and the range of today - 30 days before today? I tried to do it through scripting, but so far i can't figure out how to make that calculation in scriptmaker.

thanks again

One method...

Enter Find Mode

Set Field [YourDateField; Get(CurrentDate)-30 & "..." & Get(CurrentDate)]

Perform Find