Date - List of Sundays

• edwin_fredrick

  Old Hand

  Points: 364

  More actions

  February 3, 2004 at 11:41 pm

  #160414

  how do i get the List of Sundays between two given dates by using a select statement. say for eg. from 01-FEB-2004 to 29-FEB-2004

  should give me a list of following dates.

  01-FEB-2004

  08-FEB-2004

  15-FEB-2004

  22-FEB-2004

  29-FEB-2004

  I would like to use this in a query like

  SELECT FDATE,COUNT(*) FROM Table1

  Where FDate In (Sundays)

  Group By FDate

  To check the Transaction Count on Sundays basically.

   

   

   

   

   

   

• mccork

  SSC-Insane

  Points: 22288

  More actions

  February 4, 2004 at 1:57 am

  #492714

  You could replace your WHERE clause with:

   

  where FDate between '01 FEB 2004' and '29 FEB 2004' and datename(dw, FDate) = 'Sunday'

  
  Cheers,
  - Mark

• edwin_fredrick

  Old Hand

  Points: 364

  More actions

  February 5, 2004 at 3:31 am

  #492854

  Thank you very much Mark. So Simple Once you Know, Yet so Difficult.

  Thanks again.