I have a SharePoint List. Using CAML I need get all the Items that are modified in the current Month/Week/Year.?
Can anybody help me to achieve this?
View Complete Post
I would like to use xmlhttp request to display the current users unread email count in a webpart. I can get this to work if the user enters their username & pw, but I'm not able to get any pass-thru credentials to work. How can we set this
up to pass through the current user's credentials. We tried to set the sharepoint wfe with kerberos trusted delegation, but this doesn't seem to work.
We do not want to create an account with full access to all private mailboxes.
consider that i have columns like tax_amount,item_amount,month,year in a table..
i want to get
current month & year - tax_amount,item_amount
previus month and current year- tax_amount,item_amount
current month & previus year - tax_amount,item_amount
how to get all the values in a single select query.
i am waiting for ur reply..
I need to make a mdx query to pick the data from first day of the current month.
SELECT [Measures].[Internet Sales Amount] ON COLUMNS,
[Date].[Fiscal].[Date].MEMBERS ON ROWS
FROM [Adventure Works]
The above query returns around 4 years of data, but I need the data from first day of the current month.
Could anybody help me out!!!
It is required to retrieve the records where ONLY Start Month, Year AND End Month, Year are passed. Trying below SQL to get these with no success.
registrationdate BETWEEN(MONTH((registrationdate) = 01) AND (Year(registrationdate)= 2009)) AND ((Month(registrationdate) =03) AND (Year(registrationdate)=2010))
Help is appreciated.
I have this issue that CQWP is rendring items that it should not render. I test this with a read-only user, that should NOT see draft pages or pages with different permissions. But the read-only user do see the items, but when I click on the link I get access
denied. This access denied is correct, but why does the page items appear in the CQWP at all?
1) I use OOTB CQWP (inherits from ContentByQueryWebPart in my .webpart file) : "<type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart ....." and I have my custom xsl to get the look and feel I need
2) The issue with page items showing when status = drafts only appear when using the PublishingExpirationDate field. When I try creating new pages and give them status draft by using "check in to share draft" (logged on as an contributer/approver
user), this item wil NOT appear in the CQWP for the read-only user. When I change a pages' status from approved to draft, this item will still be shown in the CQWP, but this will point correctly to the published version. But after the pages'
expired date (PublishingExpirationDate) is expired, the page gets status "draft" (handeled by a timer job I guess), and this page item will still be rendered in the CQWP, but sending the read-only user to an access-
I have this date format from
but I just need the month and year in order to do the aggregations with...
I need to convert an invc_date from 2009-01-01 00:00:00.000 to MM-YYYY
I have tried some of the stuff but not quite working for me yet
How do I write my SQL so I get this result?
2010Januari(4)Februari(23)Mars(12)April(5)... and so on2009Januari(12)Februari(2)... and so on
I'm building a blog and want to have this as links. I have a field in the database "CreateDate".