Skip to Content
0
Former Member
Jan 12, 2011 at 10:15 PM

how to get the both weeks in a query?

28 Views

Hi,

I have to creat a query looks like:

Mon Tue Wed Thu Fri Sat Sun

Kw50 100 200 300 400 500 200 666

KW49 88 76 54 67 543 100 122

This query i have created, this format is no problem .

In the column i have create 7 columns which look like above (from monday to sunday). Each column is a restricted KF which is restricted by a calender day variable (Customer Exits, from offset 0 bis 6). THis calenderday variable get the date in the customer Exits from monday to sunday.

Input value is Calenderweek.

How can i do it with e.g calender week to get the data for the both weeks?

Thanks!