UCCE Infomaker Weekly Reports

[Nathan Luk]

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

[boyd.lynn]

Nathan,

This should do it

DATEPART( wk,Skill_Group_Half_Hour.DateTime)

Cheers

Boyd