Situation: DATEPART (week,[COLUMN]) : Based off of the parameters
supplied datepart will only display the given week of a specific year.
Does anybody know if its possible to have it return the WEEK of a MONTH
instead of the week of the YEAR _without_ using a temp table to
populate this information given a duration of dates?
If the first of the month is the 1st day of the week
then ((day+6)/7) truncated (1-7 -> 7-13, 8-14 -> 14-20, etc.)
If the first of the month is the 2nd day of the week
then ((day+7)/7) truncated (1-6 -> 8-13, 7-13 -> 14-20, etc.)
If the first of the month is the 3rd day of the week
then ((day+8)/7) truncated (1-5 -> 9-13, 6-12 -> 14-20, etc.)
If the first of the month is the 4th day of the week
then ((day+9)/7) truncated (1-4 -> 10-13, 5-11 -> 14-20, etc.)
If the first of the month is the 5th day of the week
then ((day+10)/7) truncated (1-3 -> 11-13, 4-10 -> 14-20, etc.)
If the first of the month is the 6th day of the week
then ((day+11)/7) truncated (1-2 -> 12-13, 3-9 -> 14-20, etc.)
If the first of the month is the 7th day of the week
then ((day+12)/7) truncated (1 -> 13, 2-8 -> 14-20, etc.)
.
Re: Is Project worth it? ... > with formatting instructions overlaid to structure the display of the ... > Work and Duration to each. ... > can assign the Standard calendar to the first, ... > Back to the Gantt display and assign the first resource to each task ... (microsoft.public.project)
RE: Is Project worth it? ... with formatting instructions overlaid to structure the display of the text. ... Work and Duration to each. ... can assign the Standard calendar to the first, ... Back to the Gantt display and assign the first resource to each task you've ... (microsoft.public.project)
Re: Task duration time not a round number ... It is usually easier to diagnose what's actually happening if you go to the Tools Options menu, the View tab, and choose to display dates in a format that also includes the time. ... As John pointed out, durations are ALWAYS stored and calculated internally in minutes to the nearest 10th, regardless of the units you enter or display duration in. ... It is impossible to force Project to use any other base units such as whole days or calendar weeks or months - when you see "1 d" displayed, it is only an approximation for convenience sake and the real duration value is 480.0. ... But the occurance of fractional days in the summaries is not at all unusual and if you display the times you'll see that a summary task starting, say, next Monday that has a displayed duration of 2.75 days will have it's earliest starting subtask beginning Mon at 8am and its latest finishing subtask ending Wed at 3pm. ... (microsoft.public.project)
Re: Syntax to Average a time duration (hh:mm:ss). ... my reports must display the exact number of seconds of an event. ... > I haven't heard a good reason for displaying this as minutes and seconds. ... > Duane Hookom... >> sec) of One duration,... (microsoft.public.access.queries)
Re: XML Feed Dotnet ... Once you've got the data in a dataset, use the DataView's RowFilter property... to filter down to the parts you want. ... third party to receive data in XML format which i then want to display... I have the part where i populate the dataset but how do i search within ... (microsoft.public.dotnet.framework.aspnet)
