find for previous 30 days...

[lonesomejubilee]

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

[teka]

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

[AudioFreak]

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.

[lonesomejubilee]

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

[David Jondreau]

One method...

Enter Find Mode

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

Perform Find