Newbie Questions

Re: Setting Date value to Datetime picker at runtime In Infopath Form

Hilary Stoupa — Thu, 21 Sep 2023 21:49:41 GMT

Glad the forum could help - I still look stuff up here when I get stuck! :)

Re: Setting Date value to Datetime picker at runtime In Infopath Form

PaulieDC — Thu, 21 Sep 2023 19:20:09 GMT

This is awesome. It's 2023 and I'm trying to populate a DatePicker control in InfoPath 2013 from SQL Server for use in SharePoint 2016, and this works! Thank you!

prashant.raut:
Managed to solve this issue. In reality Infopath doesn't like any other date format except yyyy-MM-dd.

Eg. as below

                XPathNavigator myNav = this.MainDataSource.CreateNavigator();
                XPathNavigator workflowDataNav = this.DataSources[0].CreateNavigator();
                XPathNavigator newNode = myNav.SelectSingleNode("//my:field7", this.NamespaceManager);

                if (newNode.MoveToAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance"))
                    newNode.DeleteSelf();
                newNode.SetValue(Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd"));

You can format separate date format in the date picker in Infopath form choice is urs....

Re: Setting Date value to Datetime picker at runtime In Infopath Form

B4d_k42ma — Tue, 14 Jul 2009 16:41:12 GMT

Actually..it dawned on me after I posted to make a calculated column that parse's the text and converts to a date..that worked. thanks anyway.

Re: Setting Date value to Datetime picker at runtime In Infopath Form

B4d_k42ma — Tue, 14 Jul 2009 16:18:35 GMT

Sorry to bump an old thread, but is there any way to do this without any code-behind?

What I'm trying to do is promote this field as a Date to a SharePoint Library. And what I'm hoping to do is filter out forms where this field is greater than or equal to [Today]-2. (In other words, I only want to see forms that are 2 days past this end date.

here is what I've got. This is the ONLY way, I can get the form to properly accept my datetime field without throwing validation errors.

My Form has a dataconnection to a web-service that is making a SQL call to a SQL 2K5 database.

Web-service call: "Select top 1 pe_end_date from pay_periods where active = 1"

And my field is equal to that value and is of datetime data type. And it properly accepts and formats the field. However when this gets promoted to my SharePoint list; it gets promoted as a single line of text and thus displays "2009-07-11T00:00:00-05:00" as the value.

Consequently, I cannot do any calculations on this field in order to filter by it. Can anyone give me any suggestions? Should I move this to SharePoint forum?

Re: Setting Date value to Datetime picker at runtime In Infopath Form

Jimmy — Tue, 31 Mar 2009 12:23:23 GMT

Thank you for your contribution, but the following pair of lines will produce exactly the same result:

string strNow = XmlConvert.ToString(DateTime.Now, "yyyy-MM-ddTHH:mm:ss");
objStartDateTimeNode.SetValue(strNow);

The following will also work just fine:

objStartDateTimeNode.SetValue(XmlConvert.ToString(System.DateTime.Now));

Re: Setting Date value to Datetime picker at runtime In Infopath Form

hortonhouse — Tue, 31 Mar 2009 11:35:24 GMT

While the following is a bit long winded it does work, I would expect a DateTime format provider to give a much more succinct block of code, but this gives precision.

Based upon an InfoPath DateTime Data Type field with its display format set to show either Date or Time, the following C# will populate this field:

string strNow = DateTime.Now.Year.ToString() + "-" +
                        (DateTime.Now.Month.ToString().Length == 1 ? "0" + DateTime.Now.Month.ToString() : DateTime.Now.Month.ToString()) + "-" +
                        (DateTime.Now.Day.ToString().Length == 1 ? "0" + DateTime.Now.Day.ToString() : DateTime.Now.Day.ToString()) + "T" +
                        (DateTime.Now.Hour.ToString().Length == 1 ? "0" + DateTime.Now.Hour.ToString() : DateTime.Now.Hour.ToString()) + ":" +
                        (DateTime.Now.Minute.ToString().Length == 1 ? "0" + DateTime.Now.Minute.ToString() : DateTime.Now.Minute.ToString()) + ":" +
                        (DateTime.Now.Second.ToString().Length == 1 ? "0" + DateTime.Now.Second.ToString() : DateTime.Now.Second.ToString());
objStartDateTimeNode.SetValue(strNow);
                    // e.g. This is how the date format needs to be for a DateTime with time only display field - objStartDateTimeNode.SetValue("2009-01-29T01:12:21");

Note the last comment showing the needed format for the inbound date time string.

Re: Setting Date value to Datetime picker at runtime In Infopath Form

Jimmy — Sat, 25 Oct 2008 10:15:15 GMT

You can also use the XmlConvert.ToString() method to convert a DateTime to an XML date, though it doesn't make much of a difference in this case. You still have to provide a format string since InfoPath won't accept dates with the time in them:

newNode.SetValue(XmlConvert.ToString(DateTime.Now, "yyyy-MM-dd"));

In either case, there's no need to convert DateTime.Now to a DateTime object, as it's already a DateTime object.

Re: Setting Date value to Datetime picker at runtime In Infopath Form

prashant.raut — Wed, 22 Oct 2008 14:49:12 GMT

Managed to solve this issue. In reality Infopath doesn't like any other date format except yyyy-MM-dd.

Eg. as below

                XPathNavigator myNav = this.MainDataSource.CreateNavigator();
                XPathNavigator workflowDataNav = this.DataSources[0].CreateNavigator();
                XPathNavigator newNode = myNav.SelectSingleNode("//my:field7", this.NamespaceManager);

                if (newNode.MoveToAttribute("nil", "http://www.w3.org/2001/XMLSchema-instance"))
                    newNode.DeleteSelf();
                newNode.SetValue(Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd"));

You can format separate date format in the date picker in Infopath form choice is urs....

Re: Setting Date value to Datetime picker at runtime In Infopath Form

prashant.raut — Wed, 22 Oct 2008 08:20:17 GMT

Now i managed to avoid the schema validation error but still i am unable to set the date value programmatically. After setting date programmatically get error on infopath form "Only Date allowed". This is really pain from microsoft.While setting the date programmatically using setValue i can set only string value but DatePicker in infopath has data type as date.

Re: Setting Date value to Datetime picker at runtime In Infopath Form

Hilary Stoupa — Tue, 21 Oct 2008 14:48:40 GMT

I think you may be running into trouble with the xsi:nil attribute -- When you set the value of your date time field, you'll need to remove that attribute. It throws a schema validation error otherwise. See this article for more info: http://blogs.msdn.com/infopath/archive/2006/11/28/the-xsi-nil-attribute.aspx

Re: Setting Date value to Datetime picker at runtime In Infopath Form

prashant.raut — Tue, 21 Oct 2008 07:20:47 GMT

I am alread doing that.

XPathNavigator newNode = myNav.SelectSingleNode("//my:field7", this.NamespaceManager);

newNode.SetValue(DateTime.ParseExact("20/10/2008","dd/MM/yyyy",null).ToShortDateString());

My form is browser form having DatePicker control with datatype as date. If u check Infopath schema it has datatype as date and i am trying to set the string value which is very obvious to generate schema validation.

PRashant

Re: Setting Date value to Datetime picker at runtime In Infopath Form

Shiva — Tue, 21 Oct 2008 03:02:30 GMT

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

Hello,

Whenever you trying to set the date value to node it should be format of string only. Before setting the value, you have to convert it into string then try to set this value.

Date = DateTime.Now.ToString("yyyy-MM-dd");

Xdocument.SelectSingleNode("<DateNodeXPath.").text = Date;

Setting Date value to Datetime picker at runtime In Infopath Form

prashant.raut — Mon, 20 Oct 2008 21:17:01 GMT

I have a date time picker to which i need to set custom date at runtime. I know that if i make datatype as Text of datetime picker there is no issue setting the date at runtime but due to comparision with other datetime picker strictly i have to keep datatype as Date.

When i try to set date of DateTime picker in Infopath form using C# code it gives me XSD validation error which is very true. Googled but no answer. Do let me know if question satisfied or need more info.

Don't ask me to share my XSN file.