Selecting records based on supplied dates..?

• Tony Harrison-409301

  Grasshopper

  Points: 24

  More actions

  February 23, 2007 at 5:17 am

  #177023

  I have a large database containing customer records, along with one column which is a date field. All fields are set as VARCHAR.

  I need to select/export records based on this date field - any customer which has a date in the last three years is required.

  Please help!

  Cheers, TH

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 23, 2007 at 5:38 am

  #691361

  Tony

  Check out GETDATE(), DATEDIFF and CAST in Books Online.

  John

• Henry Treftz

  SSCarpal Tunnel

  Points: 4207

  More actions

  February 27, 2007 at 10:18 am

  #692114

  Also look at isdate() in the BOL. If the value can not be converted to a valid date you are going to have some issues as well.

  Henry