FINDING THE DATE WHICH IS NEAREST TO CURRENT DATE

• aeri_q

  Mr or Mrs. 500

  Points: 553

  More actions

  February 2, 2014 at 3:37 pm

  #289019

  i need to find the date from a column , which is less than and is nearest to the current date .??

  any help would be appreciated

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 2, 2014 at 7:28 pm

  #1685374

  With no sample(s) of your current data all I can suggest is that you look at using the built in function GETDATE.

  For example:

  SELECT GETDATE() executing this just a minute or two before typing this reply returns

  2014-02-02 21:26:48.880

  year -month-day hour:minute:seconds:milliseconds

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  February 2, 2014 at 7:37 pm

  #1685375

  This is a double-post... here's the original