Find Todays date - 6days

[johnlyons]

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

[Zero Tolerence]

[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

[johnlyons]

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

[Lee Smith]

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

[johnlyons]

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

[Lee Smith]

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, 2006 by Guest

[johnlyons]

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.

[Lee Smith]

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

[Zero Tolerence]

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!

[johnlyons]

This worked. Thank you all for the help.