Results 1 to 3 of 3

Thread: SQLquery Sqlserver -> Access RESOLVED

Threaded View

  1. Oct 5th, 2002, 01:53 AM #1
    oh1mie
    oh1mie is offline

    Thread Starter
    Frenzied Member oh1mie's Avatar
    Join Date
    Sep 2001
    Location
    Finland
    Posts
    1,043

    SQLquery Sqlserver -> Access RESOLVED

    How i should write this sql query, than its work on access also.
    I like to have all customers who have started 20 years ago from this year

    VB Code:
    1. sSQL="select customername,startdate from customers where DATEDIFF(year, startdate, getdate())>19"
    Last edited by oh1mie; Oct 5th, 2002 at 02:57 AM.
    oh1mie/Vic

    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