I would like to create a script to attach to a lyout that would find all records that have a date of todays date - 6 days. I am stuck. please help. thanks

[Enter Find Mode]

Set Field[date; Get(CurrentDate) - 6]

[Perform Find]

You can do just what you said

Get (CurrentDate) - 6 will return a valid result

I didn't state my question correctly. I would like to find all records >todays date-6. can this be done?

This sounds the same. Maybe the result of your calculation isn't Date?

Why not tell us in what you are wanting to find with your calculation.

I.e.

Get(CurrentDate) + 6

1/4/2006 + 6 = 1/10/2006

Get(CurrentDate) - 6

1/4/2006 - 6 = 12/29/2005

or,

is it a range of dates such as 1/4/2006...1/10/2006

all files with a date in the range of 1/4/2006...1/10/2006

Lee

I have a list of bids with due dates that range from years ago to dates in the future. I want to find all bids that are greater than todays date - 6 days ago. I believe the solution provided earlier will only give me the bids for the date of today-6.

Thanks for your help

You are talking in circles.

greater than today, but less 6 days???

At least I think I'm understanding that you want a found set of records with a range of 6 days.

Let us know what your example of dates should be, and I'll post a calculation.

Use example of real dates, since your confusing me (us) as to what the result should be.

Lee

[color:red]Maybe this?

Enter Find Mode [ ]

Insert Calculated Result [ YourDateField; Get ( CurrentDate )-6 & "..." & Get ( CurrentDate ) ] [ Select ]

Perform Find [ ]

Edited January 4, 200620 yr by Guest

Sorry for the confusion hopefully this explains things better. If I have bid with the following dates

11/1/05

11/20/05

12/21/05

1/02/06

1/05/06

1/10/06

today being 1/4/06

and

today-6 being 12/29/06

I would like to retrieve all quotes >today-6 which from the example would return 1/02/06, 1/05/06 & 1/10/06.

Thanks for sticking with me on this one.

Okay, you want to go back six days and forward six days.

This will find what you described.

Enter Find Mode [ ]

Insert Calculated Result [ [color:red] YourDateField; Get ( CurrentDate )-6 & "..." & Get ( CurrentDate )+6 ] [ Select ]

Perform Find [ ]

[color:red] YourDateField = [color:red]Your Date Field

HTH

Lee

I might be wrong here too, and really, its just down to this or that, but I think he's saying he wants every day that is > (Get(CurrenDate) - 6)

So not just 6 days in advance, but all days in advace.

In which case, in your Find script you would just set the field to:

> (Get(CurrentDate) - 6)

Either way you have plenty of examples! I hope you learned something!

This worked. Thank you all for the help.