I have created a Script that allows me to see who's payment is due today,

Perform Find[] Specify, // next payment due date.

How can I subtract a specific number of days from the current date?

date - 3

date fields are numbers counting days.

-jens

You need to create a script to do this.

Enter Find Mode [ ]

Set Field [ YourTO"::YourDateField; Get ( CurrentDate ) -3 ]

Perform Find [ ]

HTH

Lee

Thank you, that was easy for me to set up.

beats the heck out of scrolling through 500 records.

Thank you very mucho

OK, this works well Enter Find Mode [ ]

Set Field [ YourTO"::YourDateField; Get ( CurrentDate ) -3 ]

Perform Find [ ]

But I need to be able to also view the current date, one day back and 2 days back and 3days back. Just by using the scroll wheel on my mouse to look at all these days.

Can this be done within this same script?

Set the field to:

Get ( CurrentDate ) - 3 & ".." & Get ( CurrentDate )

Try this and see it works for you.

Enter Find Mode [ ]

Set Field [ YourTO::YourDate; Get ( CurrentDate ) -3 & "..." & Get ( CurrentDate ) -1 ]

Perform Find [ ]

HTH

Lee

That did the trick, thank you.

Thanks, it did not need the -1 on the end took that off and it worked perfect. to cool.

Thanks Again