how to count the date weekly , monthly and fortnightly

[#1]

Hello everyone,

I have a table as given below , i want to calculate the no of count weekly , monthly and fortnightly.

weekly count- suppose we have a multiple date in one week then finally we will count 1 , same logic would be the monthly and fortnightly .

fortnightly means - in month from 1  to 15 we count 1 fortnight hence in one month we have 2 fortcount

we want to find the total count weekly, monthly and fortnightly by using the userid and dealer code...

Please help me to do this calculation.

Thanks

Manoj

userid	dealer code	date
1	1101	04-Jan-13
1	1101	29-Jan-13
1	1101	03-Mar-13
1	1101	08-Apr-13
2	1107	04-Jan-13
2	1107	08-Jan-13
2	1107	12-Jan-13
2	1107	24-Jan-13
2	1107	28-Jan-13
2	1115	06-Jan-13
2	1115	02-Feb-13
2	1115	18-Jan-13
3	1104	02-Jan-13
3	1104	08-Jan-13
3	1104	13-Jan-13
3	1104	20-Jan-13
3	1104	26-Jan-13
4	1102	02-Jan-13
4	1102	07-Jan-13

[Nicole-Smith]

See the attached example.  Make sure to look at the load script where I have created a Date table and the three charts where the weekly, fortnight, and monthly counts are.