.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to get Saturday of first week in each month

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :


   I need to get information of Saturday of first week in each month. Could you show me how to resolve this ?

View Complete Post

More Related Resource Links

dropdownbox which selects records based on criteria (TODAY, THIS WEEK, THIS MONTH, etc)


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

SSAS Calendar Week commencing with split at month

Hi all, Wonder if someone can help. Our CFO wants to see a cube calendar that shows week commencing but stops at the end of month. For example if the dates are Monday  28th   Tuesday  29th   Wednesday 30th   Thursday 1st    Friday  2nd Saturday 3rd Sunday   4th So for this example the week commencing is the 28th of Month 1 and Thursday is week commencing 1st of the next. I am having a problem seeing how I can do this. If I add the weeks to a standard calendar I get the week commencing 28th which includes the 7 days, naturally. I cannot help feeling I am missing something obvious. Cheers

Last day of month and last day of the week Using MTD,YTD

How Can I achive Last day of month and last day of the week Using MTD,YTD function in SSAS Qube ?

Calendar List View Issue - No Month, Week, Day Icons


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 do you determine that the last day of the previous month falls on a Saturday or Sunday?


How do you determine that the last day of the previous month falls on a Saturday or Sunday?

I know that this will give me the last day of the previous month




Dimension : Month and Week sorting


Time dimension structure has the following attributes

Date - YYYY-MM-DD is the Key.

Date_fmt - date represented as an integer YYYYMMDD

Week - YYYY W[1-52] (e.g. 2010 W10) in char

Month - YYYY Mon  (2010 Apr) in char

Quarter - YYYY Q[1-4]

Year - YYYY


Based on the solutions in this forum, I created a new attribute date_fmt which is of type integer and assigned as an AttributeKey.

Date is sorted, except Week and Month.


Date OrderBy : AttributeKey, OrderByAttribute : Date_fmt

OrderBy for Date_fmt, Week, Month, Quarter, Year is Key. Date_fmt has OrderBy set to Key, as there is no other option. Date_fmt AttributeHierarchyVisible : False

I am not able to assign OrderBy : AttributeKey, OrderByAttribute : Date_fmt to the Month and Week attributes.

I tried adding 2 new attributes month_fmt [1-12] and week_fmt [1-52] which are integers. Idea was to specify these 2 new attributes to the Month/Week OrderByAttribute : month_fmt/week_fmt. But not able to set these options.

Question: Since OrderBy is set to Key, why the sort is not taking effect on month and week? How can I sort month and week?

Azure One Month Pass


Just saw this Azure offer.  You can try Azure for free, no credit card required, for a full month.

25-08-2010 7-24-07 PM

Get all the details here and read the fine print (like US only)

Bookmark and Share

Crawler fails to register date properties of user profiles with the month of January, April, August


This seems to be a bug when the crawler search the user profiles in MOSS 2007.  When crawled, user profiles with a SPS-HireDate in the months of January, April, August and December will be detected, but a full-text (SQL) search returns those profiles without the HireDate field.

User profiles with HireDates in other months work correctly, returning the HireDate in the search.  And changing the month of a problematic user profile also fixes the problem.

This problem is also reflected in the fact that while we have 499 user profiles using the SPS-HireDate property,  the managed property page from the search section only has 350 items with the HireDate property.

We're running MOSS 2007 32bit with SP2 with an English language base and the Spanish language pack. I'd considered date format problems, but I can't imagine how some months would work, while others wouldn't.

Any ideas?

Applying custom CSS to the MOSS 2007 Calendar control Month view



I have a requirement to use the MOSS 2007 Calendar Control - month view is to apply a custom css to have a look and feel as per our requirements.

We tried applying the custom css to the MOSS 2007 calendar control - month view, it does take the custom css and applies it, but when i click on any date and come back to the calendar control, it changes the CSS of the MOSS calendar control back to the default one.

Let me know if anyone has any suggestion on  how to customize the calendar control for css for our intranet application.

Your response would be highly appreciated.






month days in gridview


 Hello all,

I have a challenge of which I can't figure out how to achieve it.

at this moment I have a gridview that can be dynamicly filled with cell's based upon the number of items selected (throug a drop down list) by a user.

the user then can enter some values in the cells to perform a bulk insert.

What I rather want is that the user selects a month, like august, and then  the gridview is filled with the amount of days from that month, so you get 31 cells in the gridview. second all the first cells should be filled with the daynumber for that day...

I hope the explanation is clear :)


Does anyone know a solution to this?





Get Dates from Sunday thru Saturday


I'm using the date picker and I need to know how (or if it's even possible), to select a date, and based on the date, have the actual query use the week the date was in and return all the records from that week (Sunday through Saturday)

Like - if I pick 8/24/2010 - it returns a date range of 8/22 through 8/28
I'd also like to display the date range in the report, somehow

Any ideas on how I do this?

Getting Users who logged on in last month

Hi all, Using Sql Server 2005. Is it possible to retrieve from Sql Server the name and times of all users who logged into the server in the last month? Regards Melt

Hiding other month dates in ASP .Net Calendar Control

Often we need ASP .Net calendar control in our webpages. Most of the times we require navigation in between dates of the calendar control but there can be a requirement that when we want that users should not be able to select dates from month other than the current month.Some people might be thinking in mind that Microsoft has provided theShowNextPrevMonth property of a calendar control which can be set to false in order to disable the navigation in between months. Ok, this will disable navigation but what about the dates of adjacent months shown in current month?Following is the output of a normal Calendar control when ShowNextPrevMonth is not set to false.Note the red circles in above image. July and September will allow you to navigate through other months and red circles below will allow you to select dates of adjacent months.Ok now we set the ShowNextPrevMonth property to false and see the output. Following is the output in this case.So setting out the ShowNextPrevMonth property has disabled the July and Septemberlinks but dates of adjacent months are still there which can be selected as well. How to disable/hide these? Unfortunately there is no such default property provided using which one can disable or hide these dates but fortunately doing this using code is not a complex task. Use following code a

Where to add month column?

I'm new to ASP.NET and am not sure where to put this. In my SQL server database I have a view that includes "transaction date"(TransDate) as a column. I want to create a Report (rdlc) that shows data grouped by Transaction Month. Where is the best place to add the month column - in the view, in the app's dataset, or somewhere else? I tried adding it as a column in the dataset but that does not seem to work correctly.  I don't know how to set up the column to tell it to pull the data from TransDate and use only the month. Please help. Thanks.    

Customize calendar to view next month

I was wondering if there is a way to change the calendar view on SharePoint so that it defaults to next month.  Will I have to create a custom web part for this functionality or can I create a view and manipulate it with filters? Thank you in advance.

Remove time from Month Calendar view

We have a calendar part on a page that has very narrow boxes for each day. As such we want to remove the time from appearing before the title of the event. I have managed to do this through css where there is only one event. However, have not been able to remove it where there are mutiple events. Any ideas on how this can be removed in both scenarios? Cheers, Theo

How to create a calcuated member, which will always return the date one month before the currentmemb

I need to create a calculated member in the cube script, which will be subsequently used in various other script calculations.  It needs to return the date, which is 1 month before the currentmember of the Date dimension. I tried something like this: CREATE MEMBER CURRENTCUBE.[Measures].[LastPD]   AS           PARALLELPERIOD([Date].[Calendar].[Month], 1, [Date].[Calendar].currentMember) ,VISIBLE = 1; However when I then try to check the values with this query: SELECT [Measures].[LastPD] on 0, [Date].[Calendar].[Date].members on 1 FROM [TravCSAT] ; I only get NULLs for [LastPD].  Any idea what I am doing wrong?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend