Results 1 to 3 of 3

Thread: Dates

  1. #1
    Atom Guest

    Default Dates

    I am trying to get the date for the previous week to display in an sql statement. From Date() how do I reduce it by seven days to give me a value to put in my sql statement?<BR><BR>Cheers.

  2. #2
    Eddie Campbell Guest

    Default RE: Dates

    Use DateAdd("d",-7,Date())

  3. #3
    Join Date
    Dec 1969

    Default RE: Dates

    DateAdd() should work I think?<BR><BR>Use a negative addition value.

Posting Permissions

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