Jump to content
Sign in to follow this  
lonesomejubilee

find for previous 30 days...

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.