Date-funktion help needed!

Results 1 to 2 of 2

Thread: Date-funktion help needed!

  1. #1
    juddo Guest

    Default Date-funktion help needed!

    hello.<BR>Does anyone know how to get every post that was posted yesterday, 2 days ago, 3 days, 4, 5 and six days ago?<BR><BR>This is todays posts:<BR>SQL = "SELECT * FROM MyTable WHERE Date = #"&date&"# ORDER BY Date "<BR><BR>But I also want to show yesterdays posts:<BR>What is the SQL for that.<BR><BR>And for all the posts that was posted 2 days ago.<BR>Whats the SQl.<BR><BR>Please help!<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Date-funktion help needed!

    SQL = "SELECT * FROM MyTable WHERE Date = #"&date&"#-1 ORDER BY Date "<BR><BR>

Posting Permissions

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