Date range in a script

[Surya_CS]

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.

[mr_vodka]

Enter Find Mode []

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

Perform Find []

[LaRetta]

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

[bcooney]

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.

[Surya_CS]

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.