Last week.... 1

[cranebill]

trying to get data from last week. this is what I have in my where clause:

where Format([update_date],"ww") = Format([now()],"ww") - 1;

it is erroring on now(), any idea how to use now in criteria?

 

[straybullet]

Perhaps try Date() rather than Now() - without the brackets.

Let them hate - so long as they fear... Lucius Accius

 

[cranebill]

I stripped the brackets off of Now() and it works... thanks.