How do I retrieve the first of the month for the min and the end of the month for the max
My query looks like this below…
View Complete Post
View Complete Post
I have a sqldatasource statement. How can i select current month in my statement?
Here is what i done.
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
SelectCommand="SELECT SUM(Amount) AS Total2 FROM Budget WHERE (UserId = @UserId) AND (CategoryId = 1) AND (CreateDate = @CreateDate)">
<asp:SessionParameter Name="UserId" SessionField="UserId" DefaultValue="" />
<asp:Parameter Name="CreateDate" Type="DateTime" />
in page load C#,
SqlDataSource3.SelectParameters["CreateDate"].DefaultValue = tnow.Month.ToString();
But i get this error <String was not recognized as a valid DateTime>.
How can i do it?
Any help is appreciated.
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
Just saw this Azure offer. You can try Azure for free, no credit card required, for a full month.
Get all the details here and read the fine print (like US only)
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.
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
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.
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?