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

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

Date Format error in enterprise portal

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


  I have installed ssrs in different server,ssas in different server and enterprise portal in different server.Configured and also done kerbores .Regional and language settings of all server are set to us english(dd/mm/yyyy).I have checked the regional and language settings of all server .I have checked the enterprise portal regional settings also.It is also set to us english.Iam getting date format error like

The value provided for the report parameter 'Dataset_ToDate2' is not valid for its type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportParameterTypeMismatchException: The value provided for the report parameter 'Dataset_ToDate2' is not valid for its type.

Instead of taking dd/mm/yyyy its taking mm/dd/yyyy.

I done know where Iam missing something...please help me.

View Complete Post

More Related Resource Links

Enterprise Library 4.0 error: Input string was not in a correct format.


I am trying to insert candidates information into SQL Server database. I have written the corresponding stored procedure like below in SQL server:

ALTER PROCEDURE [dbo].[USPInsertCandidate]
	@candidate_name varchar(60),
	@dob datetime,
	@gender char,
	@current_location varchar(60),
	@mobile_no_one varchar(20),
	@mobile_no_two varchar(20),
	@home_phone	varchar(20),
	@work_phone varchar(20),
	@email_id varchar(100),
	@passport varchar(20),
	@as_on_date datetime,
	@file_upload_path varchar(255),
	@availability char,
	@applied_position varchar(30),
	@max_round_id int,
	@certification_comment varchar(2000),
	@source_id int,
	@source_comment varchar(2000),
	@skillset_comment varchar(2000),
	@max_status_id int,
	@total_exp_year int,
	@total_exp_month int,
	@source_date datetime,
	@user_id int,
	@visa varchar(20),
	@qualification varchar(100)
	declare @candidate_id int;
	set @candidate_id = dbo.GetCandidateID();
	insert into candidates(candidate_id, candidate_name, dob, gender, current_location, mobile_no_one, mobile_no_two, home_phone, work_phone, email_id, 
							passport, as_on_date, file_upload_path, availability, applied_position, max_round_id, certification_comment,
							source_id, source_comment, skillset_comment, max_status_id, total_exp_year, total_exp_month, source_date,
							user_id, visa, qualification)

How To Set a Date Format In GridView Using ASP.NET 2.0

A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

How to format datetime & date with century?

Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.


error in installing portal starter kit



I tried to install portal starter kit (http://www.asp.net/downloads/archived-v11) , but I found error code (2869) in installing. Windows of my computer is VISTA.

Error is like below:

Id_token is not a valid Windows NT name. Give the complete name: <domain\username>.

User or role "id_token" does not exit in this database.

Error code 2869.

Thanks in advanced.

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

Error on Jquery Date Picker


HI all,

 I am using a Jquery datepicker in my project.There are a lot of pages where I use this date picker and w henever I select any date 

from that ,am getting an error  "length is null or not an object error on line 173"


The HMML for my datepicker control is

<input type="text" id="dpAgreementExpDate" runat="server" maxlength="10" />

How to convert Date format from dd/MM/yyyy to mm/dd/yyyy in asp.net



         I am using a text box which captures the date from the datepicker and displays in dd/MM/yyyy format in asp.net using C#

When i try to pass this text box value into the DatTime variable i am getting the error as

"String was not recognized as a valid DateTime. "


my code goes like this

DateTime dt;




i tried to use Conver.ToDateTime() function but the same error is croping up..


Can any one plz suggest me on this.....Thnks in advance

Running multiple websites in Sharepoint 2007 with AX2009 Enterprise Portal


I need to setup two separate webshops with public access and different layouts using AX2009 Enterprise Portal.

However I am uncertain how to implement two completely different layouts/designs because the Sharepoint Templates are located inside the 12 hive and not seperate for each website.

Can anybody give me some hints on how to do this - and if so, which requirements I have to meet (VSS 3.0 or MOSS Standard / Enterprise) in order to do it.

I am speculating whether I need to setup two separate web-servers with each own Sharepoint installation (and Business Connector Proxy)

Thanks in advance


While dispose the com+, encounter error: failed due to the following error: Old format or invalid ty

I have web service to invoke com+ to do business layer checking. recently, the application encountered intermittently the following error while tried to dispose the com+ instance. Appreciate anyone who help for this. thanks!   System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'System.IDisposable'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{805D7A98-D4AF-3F0F-967F-E5CF45312D2C}' failed due to the following error: Old format or invalid type library. (Exception from HRESULT: 0x80028019 (TYPE_E_UNSUPFORMAT)).   Server stack trace:    at System.IDisposable.Dispose()    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)    at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)    at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)   Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage

Transactional Publication With Article Using DATE Datatype Causes Snapshot Agent to Fail with Error

So I am using SQL Server 2008 Enterprise Edition (64Bit) and have run into a strange problem that is baffling me. I have two tables that I need to replicate.  They are identical in specification except the name (one is for monthly stats and one daily stats) CREATE TABLE [dbo].[statsDailyLite]( [EntryDate] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsDailyLite] PRIMARY KEY CLUSTERED ( [EntryDate] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO CREATE TABLE [dbo].[statsMonthlyLite]( [EntryMonth] [date] NOT NULL, [SetID] [int] NOT NULL, [ProductID] [smallint] NOT NULL, [Hooks] [int] NOT NULL, [AdViews] [int] NOT NULL, [Clicks] [int] NOT NULL, [UAdViews] [int] NOT NULL, CONSTRAINT [PK_statsMonthlyLite] PRIMARY KEY CLUSTERED ( [EntryMonth] ASC, [SetID] ASC, [ProductID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ) GO They both conatin a thousand or so test rows of data, and they are both in a transactional publication going to another SQL 2008 box. Now when the tables are empty

Insert DATE to database (format 'YYYY-MM-DD')

How can I insert BIRTHDATE into column in 'YYYY-MM-DD' format. This is my code, can anyone edit my code? Tnx String = "INSERT into concfile VALUES(BIRTHDATE('" & DateTimePicker1.Text & "', 'YYYY-MM-DD'))"

"Format exception was unhandled by user" error. . .please help. . urgent!

Hi to all developers. I'm developing a survey site and i got this error 'Format exception was unhandled by user'. .  please help me deal with this. . any help is much appreciated. .here is where the error occured(2nd line):If Not Request.QueryString("DeptCode") Is Nothing Then            Dim DeptCode As Double = Double.Parse(Request.QueryString("DeptCode"))            Session.Add("DeptCode", DeptCode)        Else            Response.Redirect("default.aspx")        End Ifthanks in advanced. .

how can I make field with date in format: dd/mm/yyyy ?

I have in model:[DisplayName("Publication date")] [DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}", ApplyFormatInEditMode = true)] [Required(ErrorMessage = "Publication date is required.")] public DateTime publication_date { get; set; } And in view:<div> <%: Html.LabelFor(model => model.publication_date) %> </div> <div> <%: Html.TextBoxFor(model => model.publication_date, new { @class = "datepicker" })%> <%: Html.ValidationMessageFor(model => model.publication_date) %> </div> But when I write in this field date: 30/11/2009 I see validation error: The value '30/11/2009' is not valid for publication_date.

Proper upgrade path for out of date portal

I have a MOSS 2007 Portal that is woefully neglected.  A quick glance showed that its version was  The table below list all the current updates. Cumulative Update KB974989 & KB974988 Oct 2009 Cumulative Update KB973410 & KB973409 Oct 2009 Cumulative Update KB971538 & KB972569 Jul 2009 Cumulative Update KB968857, KB968850, &KB968851 Jun 2009 SP2 April 2009 Cumulative Update KB963654 & KB961755 Feb 2009 Cumulative Update KB960010 & KB960011 Dec 2008 Cumulative Update KB956056 & KB956057 Aug 2008 Infrastructure Update KB951695 & KB951297 Jul 2008 SP1 + KB948945 Feb 2008 SP1 + KB941274 Jan 2008 SP1 + KB941422 Jan 2008 SP1 October 2007 public update   Do I have to apply them all in order or can I simply jump straight to the cumulatives in order?  Are there any of other considerations I should be aware of?

How do I format a date time field in a CQWP to YY-MM-DD ?

Hi. I have been trying to get the date-time to look good for some time now, but have failed. I have a Content Query web part that picks up article pages from a page library. The pages contains a field called 'article date'. I want to show just the 'Title' and the 'Article date'. Doing this default gives me: My title 10-09-03 00:00:00 I want it to be: My title 10-09-03 Is this possible? I'm starting to realize that I probably have to edit the xsl styles for this webpart but if thats the answer, how do I do that? ThanksThomas Balkeståhl - Technical Specialist - SharePoint

Format Date in TextBoxFor

I've been trying to format the date in a view form in a textboxfor and it seems everything I try doesn't seem to work. I found this great partialview example but it doesn't work when applied to EditorFor. Again works great when using the DisplayFor HTML helper method but still spits out the time at the end when trying to format for a textbox.If anyone has any suggestions or answers I would be greatly appreciative.Jim

Error during Sharepoint Foundation as well as in Sharepoint Enterprise installation

Hello All I have Windows 7 Professiona 64 bit laptop. I have installed Sql Server 2008 r2 and Visual Studio 2010 professional. Nowwhenever I try to execute prereuisite it gives me error. Here is the log files If I installed Sharepoint Foundation, It shows error, please review following log during prerequisite wizard 2010-09-05 01:07:45 - Processor architecture is (9) 2010-09-05 01:07:45 - Reading the following string value/name... 2010-09-05 01:07:45 - Common Startup 2010-09-05 01:07:45 - from the following registry location... 2010-09-05 01:07:45 - SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders 2010-09-05 01:07:45 - The value is... 2010-09-05 01:07:45 - C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup 2010-09-05 01:07:45 - Trying to remove the startup task if there is any. 2010-09-05 01:07:45 - C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup\SharePointServerPreparationToolStartup_0FF1CE14-0000-0000-0000-000000000000.cmd 2010-09-05 01:07:45 - Error: Startup task doesn't exist. This is not a continuation after a restart. 2010-09-05 01:07:45 - The following file does not exist: 2010-09-05 01:07:45 - C:\Users\sonashish\Downloads\SharePointFoundation\PrerequisiteInstallerFiles\FilterPack\FilterPack.msi 2010-09-05 01:07:45 - Locating the following command line arguments file: 2010-09-05 01:07:45 - C:\Users\sonashish\Downloads\SharePointFo
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