automate querry

[grizzlyjdw2]

is there a way to automate a querry to run for the current week?

for example if i ran it today it would run for 1-24-10 -- 1-30-10

 

[Guus2005]

To run a query each day for a week, you need to program the form timer event.
To run a query with a dynamic date variable, use

select * from tablename where somedate between date and date+7

Enjoy!

 

[grizzlyjdw2]

that isn't going to go back and pick up the previous days in the week is it?

like if i run it for jan 27 i want it to pull 1-24-10 -- 1-30-10

is that possible?

 

[gemma-the-husky]

so you need to decide which week day is the first day (eg monday) and if today isnt a monday, go back till you get one.

then use mondaysdate to mondaysdate+6 (rather than plus 7)

 

[grizzlyjdw2]

ok, that makes sense. how would you do that in SQL though?