parameter query - criteria

[action]

I am trying to create a parameter query to select dates for a pay week but can't find the right way of doing this. I can get the query critria working using:

>=Now()-7 this gives me the last 7 days but I need to add the parameter of the last day of the payweek.

Any body help?

Thanks

 

[Fuga]

I need to add the parameter of the last day of the payweek.

Not sure what you want to do here, but maybe you can use the weekday() or day() functions?

Fuga.

 

[action]

thanks Fuga. got it woking ok thanks