Re: Formatting date query Column by week.
From: Gary Walter (garylwpleasenospam_at_wamego.net)
Date: 09/22/04
- Next message: John Spencer (MVP): "Re: Rounding numbers"
- Previous message: jk: "Zero values in query"
- In reply to: Raj: "Formatting date query Column by week."
- Next in thread: Raj: "Re: Formatting date query Column by week."
- Reply: Raj: "Re: Formatting date query Column by week."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 17:11:59 -0500
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
>
- Next message: John Spencer (MVP): "Re: Rounding numbers"
- Previous message: jk: "Zero values in query"
- In reply to: Raj: "Formatting date query Column by week."
- Next in thread: Raj: "Re: Formatting date query Column by week."
- Reply: Raj: "Re: Formatting date query Column by week."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
