Problem with Time

• Rowell Cruz

  Grasshopper

  Points: 22

  More actions

  June 13, 2006 at 4:08 am

  #69115

  Good day!

  I am currently doing a module where I should be able to generate reports.

  I have a schedule table and an appointments table.

  Upon combining the two tables, I should be able to produce:

  1) Available and Unavailable schedules

  2) Available schedules only

  3) and Unavailable Schedules

  Please help me because I am havong problem regarding the datatype datetime

  I need to finish this before friday.

  Thanks!

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  June 13, 2006 at 8:28 am

  #643411

  What problem are you having with the datatype? Is this related to your other post in this forum?

  K. Brian Kelley
  @kbriankelley

• Ward Pond

  SSC Eights!

  Points: 999

  More actions

  June 18, 2006 at 12:16 am

  #644490

  Hello Rowell..

  Take a look at the DATEPART function in BOL.  That should get you started.

  ---

  Take care..

  - Ward Pond
  blogs.technet.com/wardpond