Jump to content

Script to show records by day and month


This topic is 5774 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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[]

Link to comment
Share on other sites

This topic is 5774 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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