SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: Access DateAdd("d", -30, Date)

  1. Feb 8, 2011 12:45 #1
    K. Wolfe
    K. Wolfe is offline
    Always A Novice bronze trophy
     K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    1,863
    Mentioned
    28 Post(s)
    Tagged
    0 Thread(s)

    Access DateAdd("d", -30, Date)

    Having trouble making a query to show posts that are 30 days and older. What might the SQL look like for this?
    <?php
    //Kyle Wolfe
    echo devBlog("My Dev Notes");
  2. Feb 8, 2011 13:11 #2
    r937
    r937 is offline
    SQL Consultant silver trophybronze trophy
     SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,470
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    ... WHERE x.datecolumn <= DateAdd("d", -30, Date())
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
  3. Feb 8, 2011 14:48 #3
    K. Wolfe
    K. Wolfe is offline
    Always A Novice bronze trophy
     K. Wolfe's Avatar
    Join Date
    Nov 2003
    Location
    Columbus, OH
    Posts
    1,863
    Mentioned
    28 Post(s)
    Tagged
    0 Thread(s)
    Ah there we go. Thank you.
    <?php
    //Kyle Wolfe
    echo devBlog("My Dev Notes");
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules