InfoPath 2010 - Date Picker problem when SetVal from CodeBehind

Recently we came across a problem in InfoPath 2010 DateTime Control. When we assign a value in code-behind, the text box is marked red and asking for a valid date. However the date was valid and when we type the same date, it accept the same date. The assignment was as follows in code behind which produces the error

MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:grpFeeDetails/my:dateDPO", NamespaceManager).SetValue(l_oDateTimeDateDPO.ToShortDateString());

Identified Problem
Basically the issue is with the format of the date. When we use ToShortDateString, then the format is not compatible with the InfoPath 2010 Date Format.

Resolution
To resolve this issue we used the following code

MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:txtDOB", NamespaceManager).SetValue(l_oDateTimeDOB.ToString("yyyy-MM-dd"));

The Important Point is this DateTime Format
l_oDateTimeDOB.ToString("yyyy-MM-dd")

Thanks to this post which help us to resolve this issue
InfoPath 2010 date and time picker control basics
http://www.bizsupportonline.net/infopath2010/infopath-2010-date-and-time-picker-control-basics.htm



Comments

  1. Anand SubramanianApril 4, 2014 at 4:30 AM

    Thanks so much. Was in this exact prb and your solution worked, even 3 years later...:)

    ReplyDelete
  2. MessiFebruary 26, 2020 at 4:20 AM

    cloud managed switch, thousands of switch ports can be configured and monitored instantly over the web. Without needing a physical connection between switches, you can remotely configure them for access devices, assign voice VLANs, control PoE, and more, with just a few simple clicks and without on-site IT. By managing your network through the cloud you can provision remote sites, deploy network-wide configuration changes, and easily manage campus and distributed networks without IT training or dedicated staff.

    ReplyDelete

Post a Comment

Popular posts from this blog

Export Data from AX 2012 - using DIXF (Data Migration Framework)

Importing is a well known task using DIXF, but at times we do need to export as well and then import it back in AX 2012. The export task can be done with the help of this information. https://technet.microsoft.com/en-us/library/dn144987.aspx Define the format of your source data Open  Data Import/Export Framework  >  Setup  >  Source data formats . Click  New , enter a name and a description, and then select  AX  from the  Type  list. Define a processing group to export data from Microsoft Dynamics AX Change the company to  CEU . In  Data Import/Export Framework , click  Common  >  Processing group , and then click  New  to create a new processing group. Set the group name to  Export-Cust  and add a description. Click  Entities  to select the entities to include in the processing group. In the  Select entities for processing g...
Read more

The virtual path maps to another application, which is not allowed

Image
During the development we came across this issue, which wasted a lot of our precious time. So I decided to share its solution with everyone. We have Project and Sub-Project Structure i.e. we have a root project and several sub-projects. The ROOT Project is entitled as TEMS8 and all other subprojects have been configured as per the image below. (Click on the image for large size) Now after setting up everything on a new Machine, we came across the Error as The virtual path maps to another application, which is not allowed Finally after investigation, we figured out that we have created multiple virtual directories which mainly causes the issue. For instance, we have another virtual directory created for DATADEF which is inside the virtual directory of TEMS8. So this was the main issue. The resolution was to remove the DATADEF Virtual Directory. Everything worked out perfectly, once we removed the inner virtual directory. We should not have something like this image below  W...
Read more

Agile Management - TFS (Priority, Stack Rank and Severity)

As per Microsoft Documentation Source http://msdn.microsoft.com/en-us/library/dd983994.aspx Priority A subjective rating of the bug, issue, task, or test case as it relates to the business. You can specify the following values: 1 :  Product cannot ship without the successful resolution of the work item, and it should be addressed as soon as possible. 2 :  Product cannot ship without the successful resolution of the work item, but it does not need to be addressed immediately. 3 :  Resolution of the work item is optional based on resources, time, and risk. Stack Rank A subjective rating of the user story, task, issue, or bug compared to other work items of the same type. An item that is assigned a lower number should be fixed before an item that is assigned a higher number. (Agile and CMMI process templates) Severity A subjective rating of the impact of a bug on the project. You can specify the following values: 1 - Critical 2 - High ...
Read more