By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,605 Members | 1,346 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,605 IT Pros & Developers. It's quick & easy.

DateAdd help

P: n/a
I am using code found within this group. It utilizes the DateAdd
function.

This is the query:

SELECT DateAdd("d",-Weekday([ClockInDate]),[ClockInDate])+1 AS WeekOf,
TimeClockHistory.Employee
FROM TimeClockHistory
GROUP BY DateAdd("d",-Weekday([ClockInDate]),[ClockInDate])+1,
TimeClockHistory.Employee;

Ultimatly, when this is run, it generates a report with Clock In and
Clock out times, per day in a new column.

Works Great!

However, is there a way I can filter this to specific dates? If have
found that by changing "ClockInDate" to "[Date1], this allows the user
to specify one week. I want them to be able to specify 2 weeks..

Any suggestions? I can clarify more if need be.
Thank you!

~Drum2001

Feb 16 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.