UCCE Infomaker Weekly Reports

Unanswered Question
Dec 16th, 2007

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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
boyd.lynn Mon, 01/07/2008 - 08:36

Nathan,

This should do it

DATEPART( wk,Skill_Group_Half_Hour.DateTime)

Cheers

Boyd

Actions

This Discussion