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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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