I have a very simple database and would like to write a script to find all records for the last week (all records whose date is in the range "7 days ago ... today's date").

I can do it all except the "7 days ago" bit. Any suggestions gratefully received.

Enter Find Mode []

Set Field [ YourDate; "≥" & Get ( CurrentDate ) - 7 ]

Perform Find []

If you have dates greater than today's date then you'll need a range so change would be:

Set Field [ YourDate; [color:black]"≥" & Get ( CurrentDate ) - 7 [color:green]& ".." & Get ( CurrentDate ) ]

Hi John!!

Ooops! I forgot to remove the part in bold black!!

Edited April 4, 200817 yr by Guest

It could get more complicated if when it's Wednesday and you want last week's records, you really want Monday-Friday of the last week.

Wow ... thanks Mr Vodka, and the rest who replied. I don't fully understand what I did, but I followed the instructions and after a couple of screw ups ... it worked!

Totally cool! Thanks again. Great forum.