DateAdd help

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • drum2001@gmail.com

    #1

    DateAdd help

    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,
    TimeClockHistor y.Employee
    FROM TimeClockHistor y
    GROUP BY DateAdd("d",-Weekday([ClockInDate]),[ClockInDate])+1,
    TimeClockHistor y.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 "ClockInDat e" 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

Working...