var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: w/e date
I want to run query and use this criteria, but not sure how to put it in.
Lets say the pay period ends on 12/1/06 I want a prompt to ask me the week ending and include the previous 6 days. So it will include 12/1/06 and the 6 days before that.
You can use the DateAdd() function to subtract 6 days from the given date.
so it would be like this?
right now i'm doin
Between [Beginning Date] And [Ending Date]
Its always 7 day. I just wanna make it so you enter the Ending Date
Last edited by Jay59; 12-07-06 at 17:14.
Between DateAdd("d",-6,[Ending Date]) And [Ending Date]
Thanks bro, much appreciated.