Date Query

Results 1 to 2 of 2

Thread: Date Query

  1. #1
    Join Date
    Dec 1969

    Default Date Query

    Hi I have an access 2000 db with a table called timetrack. I have two fields timetrack.jobnumber and timetrack.trackdate that store jobnumbers and dates. <BR>Can anyone tell me what the SQL code is to extract a recordset that pulls all of the jobnumbers for the current week.<BR><BR>Any help would be appreciated.<BR><BR>Thanks<BR><BR>Steve<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Date Query

    If your week&#039;s are going from Sunday to Saturday and <BR>and Sunday is your system&#039;s setting for 1st day of week then<BR>your between clause could be<BR><BR>Between " & DateAdd("d", -(Weekday(Date()-1),Date())<BR>& " AND " & DateAdd("d", 7 - Weekday(Date(), Date())<BR><BR>of course you&#039;ll have to enter the appropriate delimiters for your db

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts