UCCE Infomaker Weekly Reports

Unanswered Question
Dec 16th, 2007
User Badges:
  • Bronze, 100 points or more

Hi all,


I'm trying to build some weekly reports in infomaker but can't quite figure out the convert statement, I pulled the daily one from the out of the box reports:


convert( datetime, convert( varchar(10), Skill_Group_Half_Hour.DateTime, 112 ))


But does anyone know how to convert to weekly?


Cheers,

Nathan

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
boyd.lynn Mon, 01/07/2008 - 08:36
User Badges:

Nathan,


This should do it


DATEPART( wk,Skill_Group_Half_Hour.DateTime)


Cheers


Boyd

Actions

This Discussion