I have to find the no of the week, dies anyone know a way to capture the week no Ex:
View Complete Post
I have a dropdownbox which I want to use to search records based on a timescale. The gridview populates results based from that search.
So here is how I want to work this;
If a user selects "today" - a list of records input today are populated. If "this week" is selected, a list of all records added within that week from todays date is populated.
I created a forum on this issue previously but to no avail whatsoever. How do I work around this problem?
Help would be much appreciated
We have a unique requirment where we have our own start day of a week and end day of a week(C#),
Contrary to the existing Date Time class whose start day is Sunday and end day is Saturday, we have Wednesday as our start day and Monday as our EndDay (and this will vary per client).
and we need to implement the following logic
a) for a given date get the start Date of a week and end Date of a week
Ex: based on the above if the current day is 23/Sep/2010 (Thur) we need to get 22/Sep/2010 (Wed) as our Start Day and 27/Sep/2010 (Mon) as our end day
Can anyone help here?
I have scheduled a custom timer job to run for weekly two times using the spschedule. the string used in the feature event was
"weekly between tue 23:00:00 and thu 23:00:00"
But the problem is i have the job is running only once with the above schedule.How can i run the job twice a week on specific days.
Please share your ideas/solutions to run the custom timer job in MOSS as per the above schedule.
i try to use select statement to select records within a week from orderdate. like,
"select * from order where orderdate <= DATEADD(day,7,orderdate)";
correct me if wrong.
how to create week view,day view in asp.net
I need to write a automatic query. Please see below for example.
Date: 4/4/2010 (Monday), 4/5/2010 (Tuesday), 4/6/2010 (Wednesday)
So from every Monday - Sunday (End of the week) the result = Week of October 4th 2010
Date Day Wanted Result
4/4/2010 Mon Week of Oct 4 2010
4/5/2010 Tue Week of Oct 4 2010
4/6/2010 Wed Week of Oct 4 2010
4/7/2010 Thur Week of Oct 4 2010
4/8/2010 Fri Week of Oct 4 2010
4/9/2010 Sat Week of Oct 4 2010
4/10/2010 Sun Week of Oct 4 2010
4/11/2010 Mon Week of Oct 11 2010
Thanks loadzzz in advancee
I'm trying to setup a Calendar view for a list in SharePoint 2010. Everything is working the way I want, except there are no icons to change the view from Month, Week, or Day. Right now, if someone clicks on a date on the calendar, it switches to the Day
view. But there is no way for them to go back to the month view.
I open the page in SharePoint Designer, and in the Design view I can see three icons on the Calendar (Month, Week, Day). But at no time do these icons show up anywhere except the design view.
I want it to have the arrow buttons, the month and year (which are already displaying) and then the icons to change the view. How do I get them to appear?
How to retreive week number in SSRS if i have date 09/25/2010 in Expression
This is my table with employees data.Right now i gave only 1 employee data of 4 weeks.How to find whether the employee is getting weekoff in the same day for all 4 weeks,3 weeks 2 weeks.similarly other employees and return count.For example if the employee is getting weekOff on saturday for all 4 weeks then we can count it as 1.I want reports like this.Some employee may get weekOff for 2 days consistenly for 4 weeks say Saturday and SUnday then that result should be display in 3rd row.If the employee is getting weekOff on saturday for last 3 weeks and 4th week on sunday then we should add count in 3weeks column i.e 2 row 3rd column.In 4th week column it will be 0.ConsistencyOff Across4weeks 3weeks 2weeks0 2% 2% 2%1 98% 98% 98%2 0% 0% 0%CREATE TABLE Test1( empno int, MatchingOff varchar(10),atnDate datetime )SET IDENTITY_INSERT mytable ONInsert into TestTable(empno,MatchingOff,atnDate)select '101','Off','8/1/2010' union allselect '101','16:00','8/2/2010' union allselect '101','14:00','8/3/2010' union allselect '101','17:00','8/4/2010' union allse