number of days in view

• cotzan

  SSC Enthusiast

  Points: 160

  More actions

  February 16, 2009 at 7:28 am

  #130948

  Hi Friend.

  i wanto calculate number of days from past to now in view. there is a code from my view.

  CONVERT(varchar(20), TbC.DtContactDate, 104) AS StContactDate and that query gives me 02.02.2009 but i have to show like that 02.01.2009(before 14 days). shortly how can i counting number of day from past to today.

  Regards.

• JestersGrind

  SSCertifiable

  Points: 5812

  More actions

  February 16, 2009 at 7:42 am

  #944532

  This will get the number of days between today and the date in the DtContactDate column:

  DATEDIFF(dd, DtContactDate, GetDate()) AS NumberOfDays

  Greg

• cotzan

  SSC Enthusiast

  Points: 160

  More actions

  February 16, 2009 at 7:59 am

  #944552

  ok, solved :).

  thank you very much Greg.