Need help

[andreluiz]

Hi,

There are a way to automate a find Requests? For example:

I made the following script:

Go to Layout["Resumo do mes"](Expense Report)]

Perform Find[Restore]

Sort Records [Restore; No dialog]

The Find Requests is:

Date of End of Month >=*/*/2009

Every year I have to change the Find Request (in the past the Find Request was >=*/*/2008

There are a way to automate this? I tried to create a field (name dtfr) to be the Date to the Find Request, but didn´t know how indicate this field to be the Find Requests.

Thanks for help!

[comment]

Stored requests cannot be dynamic. You need to use the following pattern:

Go to Layout["Resumo do mes"](Expense Report)]

Enter Find Mode []

Set Field [ Date of End of Month ; ]

Perform Find []

Sort Records [Restore; No dialog]

---

(*) IIIUC, you are looking for records in the current year or later, so the calculation could be:

">" & Get ( CurrentDate ) - DayofYear ( Get ( CurrentDate ) )

[andreluiz]

Thank you very much! Works fine!

Just one more help:

It is possible that the be related to a field that I can modify?

Sometime I need to see some info in the past years and If I can just change in a field the criteria it will be very good.

Best Regards and thank you again!

[comment]

I am not sure I understand your question.

[andreluiz]

Ok,

You teach me and send me the following script:

Go to Layout["Resumo do mes"](Expense Report)]

Enter Find Mode []

Set Field [ Date of End of Month ; ]

Perform Find []

Sort Records [Restore; No dialog]

The ] that you send to me is ">" & Get ( CurrentDate ) - DayofYear ( Get ( CurrentDate ) )

It is possible to link a field to this calculate?

It´s because If I need to see and show in the layout some info in a past year (not in the current year or later) I will have just to change the date in this supposed field and then the script will be the same, but with another .

Thanks

[comment]

You could have a global date field and change the script so that it looks for records in the same year. The calculated criteria then could be:

Date ( 1 ; 1 ; Year ( gDate ) ) & ".." & Date ( 12 ; 31 ; Year ( gDate ) )

if that's what you mean.