Get Current Date minus 3 days

[cul8ter]

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?

[jteich]

date - 3

date fields are numbers counting days.

-jens

[Lee Smith]

You need to create a script to do this.

Enter Find Mode [ ]

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

Perform Find [ ]

HTH

Lee

[cul8ter]

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

beats the heck out of scrolling through 500 records.

[cul8ter]

Thank you very mucho

[cul8ter]

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?

[comment]

Set the field to:

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

[Lee Smith]

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

[cul8ter]

That did the trick, thank you.

[cul8ter]

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

Thanks Again