script to find records from today back 30 days?

[homepress]

Any help or suggestions appreciated..I have searched hard and solution is elusive.

thanks

[gug]

If every record has a date, why dont you just search a date 30 days ago?

[LaRetta]

Hi homepress,

You might try:

Enter Find Mode [ ]

Insert Calculated Result [ dateField ; Status(CurrentDate) - 30 & "..." & Status(CurrentDate) ]

Perform Find [ ]

The datefield must be on the layout.

With vs. 7, you don't need the date field on the layout because you can use:

Enter Find Mode [ ]

Set Field [ dateField ; Get(CurrentDate) - 30 & "..." & Get(CurrentDate) ]

Perform Find [ ]

You will of course want to insert an Allow User Abort [ Off ] and Set Error Capture [ On ] at the beginning and trap for errors (such as no records found) yourself.

LaRetta

[-Queue-]

One tweak: you need to enclose 'Status(CurrentDate) - 30' and 'Status(CurrentDate)' with DateToText( ).

[LaRetta]

Thanks JT. I'm having trouble remember pre-7 speak. I should have tested it - my apology for the error, Homepress - I was in a bit of hurry. As it was, I had to really think about what Get(CurrentDate) replaced.

[homepress]

LaRetta:

Thanks. I tried the caculated result but I get digits (numbers) in the date field

instead of the dates...

[-Queue-]

See my post above.

[homepress]

Queue and Laretta:

Thank ya so much! Got it and learned a lot at the same time. You guys rock!