Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Bronze

UCCE Infomaker Weekly Reports

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 REPLY
New Member

Re: UCCE Infomaker Weekly Reports

Nathan,

This should do it

DATEPART( wk,Skill_Group_Half_Hour.DateTime)

Cheers

Boyd

108
Views
0
Helpful
1
Replies