Calculate Date and Time with InfoPath template for SharePoint form library full of xml files - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Calculate Date and Time with InfoPath template for SharePoint form library full of xml files

Last post 07-20-2013 05:05 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-20-2013 01:55 AM

    Calculate Date and Time with InfoPath template for SharePoint form library full of xml files

    I have a PDF Form that creates a xml file when completely filled and submitted and they are saved within a sharepoint form library.  I would like to utilize the InfoPath template to calculate the date and time to utilize the Gnatt view for this library.  The problem is Sharepoint views all the xml data as strings and the calculated columns in sharepoint are not usable for Gnatt view.

    The field names are DepartDateRow2, DepartDateRow6, DepartTimeRow2 and DepartTimeRow6 for the combination of dates and time.  The format of the date is MM/DD/YYYY and time is HHMM.  I would like to combine DepartDateRow2 with DepartTimeRow2 to create the start position and combine DepartDateRow6 with DepartTimeRow6 to create the finish position for the Gnatt view.

    How do I create this value with in the InfoPath template so when I import a XML file the data is automatically populated?

    <DepartureDateRow2>08/17/2013</DepartureDateRow2> 

    <DepartureDateRow6>08/18/2013</DepartureDateRow6>

      <DepartureTimeRow2>0900</DepartureTimeRow2>
      <DepartureTimeRow6>2030</DepartureTimeRow6>
  • 07-20-2013 05:05 PM In reply to

    Re: Calculate Date and Time with InfoPath template for SharePoint form library full of xml files

    You need to make sure it's in the correct date format for XML - that's 2013-08-17.

     

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.