Re: Formatting date query Column by week.

From: Raj (anonymous_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 04:36:36 -0700

Gary,
Thank for the help but I am having a problem. I put the
code in the Criteria and first I got an error: "The
expression you entered has an invalid. (dot) or !
operator or invalid parentheses. I and parentheses on
both end of the formula and got this error "Undefined
function 'PIVOT' in expression"
Thanks.
Raj

>-----Original Message-----
>Hi Raj,
>
>Is "last day of work week" = Friday?
>
>PIVOT [DateField]-(Weekday([DateField])-6)
>
>If Saturday
>
>PIVOT [DateField]-(Weekday([DateField])-7)
>
>Please respond back if I have misunderstood.
>
>Good luck,
>
>Gary Walter
>
>"Raj" <anonymous@discussions.microsoft.com> wrote in
message
>news:196601c4a0c5$82051870$a601280a@phx.gbl...
>>
>> I am using this function in a Cross Tab Format
>> ([research_completed],"ww") to pull the weekly status
for
>> employees. What I would like to do is have the last
day
>> of the work week displayed at the top of the columns
>> instead of the number of the week. I hope this is
>> possible.
>> Thanks
>>
>
>
>.
>

Loading