Results 1 to 11 of 11

Thread: [RESOLVED] Need help with date

Threaded View

  1. Jul 29th, 2008, 05:12 AM #1
    usamaalam
    usamaalam is offline

    Thread Starter
    Frenzied Member usamaalam's Avatar
    Join Date
    Nov 2002
    Location
    Karachi
    Posts
    1,308

    Resolved [RESOLVED] Need help with date

    Hello everybody,

    I need some hint about WHERE clause for my query. I have a customer table and a session history table with CustomerID as foreign key and LoginDate. When a customer logs in, a record is entered in session history table with current date and time.

    I need to pick all the customers who have NOT logged in for last 15 days.

    Any idea??

    Thanks.
    Last edited by usamaalam; Jul 30th, 2008 at 06:38 AM. Reason: Not resolved
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width