Post reply

Date Range query

  • April 6, 2005 at 6:31 pm

    #92797

    Hi, I am trying to get birthdates out of a table that fall between two dates.

    For example all birthdays that fall between 03/19 - 04/27 (dd/mm)

    The field birthdate is a datetime datatype

    Any ideas.

  • April 6, 2005 at 7:43 pm

    #551019

    convert(varchar(5), birthdate, 101) between '03/19' and '04/27'

  • April 6, 2005 at 7:49 pm

    #551020

    Thanks for that, works a treat

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply