<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Recording time values with esrifieldTypeDate different between web app/connect or field app in ArcGIS Survey123 Questions</title>
    <link>https://community.esri.com/t5/arcgis-survey123-questions/recording-time-values-with-esrifieldtypedate/m-p/1597732#M61790</link>
    <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;I'm working on building a survey using a feature service that has two fields:&lt;/P&gt;&lt;P&gt;'&lt;STRONG&gt;Start_Date&lt;/STRONG&gt;' and '&lt;STRONG&gt;Start_Time&lt;/STRONG&gt;' (both using data type "&lt;EM&gt;Date&lt;/EM&gt;" set in ArcPro)&lt;/P&gt;&lt;P&gt;Ideally, I would have preferred to use "&lt;EM&gt;Date only&lt;/EM&gt;" and "&lt;EM&gt;Time only&lt;/EM&gt;" fields, but unfortunately, "Time only" isn't supported when publishing web layers to Portal.&lt;/P&gt;&lt;P&gt;That being said, I'm running into an issue with recording values for the &lt;STRONG&gt;'Start_Time'&lt;/STRONG&gt; field. The Survey123 Web App records values differently (or not at all) compared to Survey123 Connect or the Field App. Here's a breakdown of the questions involved:&amp;nbsp;&lt;/P&gt;&lt;TABLE width="504px"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;type&lt;/TD&gt;&lt;TD width="123.675px"&gt;name&lt;/TD&gt;&lt;TD width="95.85px"&gt;default&lt;/TD&gt;&lt;TD width="183.975px"&gt;calculation&lt;/TD&gt;&lt;TD width="127.117px"&gt;constraint&lt;/TD&gt;&lt;TD width="40px"&gt;bind::esri:fieldType&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;text&lt;/TD&gt;&lt;TD width="123.675px"&gt;time_24h&lt;/TD&gt;&lt;TD width="95.85px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="183.975px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="127.117px"&gt;(int(substr(.,0,2))&amp;lt;24) and (int(substr(.,3,5))&amp;lt;60)&lt;/TD&gt;&lt;TD width="40px"&gt;null&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;date&lt;/TD&gt;&lt;TD width="123.675px"&gt;date_placehold&lt;/TD&gt;&lt;TD width="95.85px"&gt;12/31/1899&lt;/TD&gt;&lt;TD width="183.975px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="127.117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="40px"&gt;null&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;dateTime&lt;/TD&gt;&lt;TD width="123.675px"&gt;start_time&lt;/TD&gt;&lt;TD width="95.85px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="183.975px"&gt;if(${date_placehold} != '' and ${time_24h} != '', concat(format-date(${date_placehold}, '%Y-%m-%d'), 'T', format-date(${time_24h}, '%H:%M:%S')), '')&lt;/TD&gt;&lt;TD width="127.117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="40px"&gt;esriFieldTypeDate&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Essentially, the user will only see the &lt;STRONG&gt;${time_24h}&lt;/STRONG&gt; field. They will enter the time in 24-hour format, and this time will then be joined with a default date of &lt;EM&gt;12/31/1899&amp;nbsp;&lt;/EM&gt;to create the &lt;STRONG&gt;${start_time}&lt;/STRONG&gt; field. This is ultimately the value that gets stored when the user submits the survey. I have to use the &lt;EM&gt;esrifieldTypeDate&lt;/EM&gt;&amp;nbsp;because of the limitation when publishing a web layer with the "Time only" data type. It seems a bit convoluted, and I'm open to any better alternatives to achieve this outcome.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;So here's the issue between the web app/connect or field app:&lt;/P&gt;&lt;P&gt;In &lt;U&gt;connect&lt;/U&gt;, the user should be able to type 13:30 into ${time_24h} to trigger the calculate on ${start_time}. This results with "Saturday, December 31, 1899" "1:30PM". This functions exactly how I intend on connect/field app.&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, in the &lt;U&gt;web app&lt;/U&gt;, the user types 13:30 into&amp;nbsp;${time_24h} and no calculate is performed in&amp;nbsp;${start_time}.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;I've read that dates are stored exclusively as decimal dates on the web app, so I think this is where my problem arises. Any input or suggestions to modify what I have would be appreciated.&amp;nbsp; &amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 20 Mar 2025 19:27:35 GMT</pubDate>
    <dc:creator>MIetronShahbodaghloo</dc:creator>
    <dc:date>2025-03-20T19:27:35Z</dc:date>
    <item>
      <title>Recording time values with esrifieldTypeDate different between web app/connect or field app</title>
      <link>https://community.esri.com/t5/arcgis-survey123-questions/recording-time-values-with-esrifieldtypedate/m-p/1597732#M61790</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;I'm working on building a survey using a feature service that has two fields:&lt;/P&gt;&lt;P&gt;'&lt;STRONG&gt;Start_Date&lt;/STRONG&gt;' and '&lt;STRONG&gt;Start_Time&lt;/STRONG&gt;' (both using data type "&lt;EM&gt;Date&lt;/EM&gt;" set in ArcPro)&lt;/P&gt;&lt;P&gt;Ideally, I would have preferred to use "&lt;EM&gt;Date only&lt;/EM&gt;" and "&lt;EM&gt;Time only&lt;/EM&gt;" fields, but unfortunately, "Time only" isn't supported when publishing web layers to Portal.&lt;/P&gt;&lt;P&gt;That being said, I'm running into an issue with recording values for the &lt;STRONG&gt;'Start_Time'&lt;/STRONG&gt; field. The Survey123 Web App records values differently (or not at all) compared to Survey123 Connect or the Field App. Here's a breakdown of the questions involved:&amp;nbsp;&lt;/P&gt;&lt;TABLE width="504px"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;type&lt;/TD&gt;&lt;TD width="123.675px"&gt;name&lt;/TD&gt;&lt;TD width="95.85px"&gt;default&lt;/TD&gt;&lt;TD width="183.975px"&gt;calculation&lt;/TD&gt;&lt;TD width="127.117px"&gt;constraint&lt;/TD&gt;&lt;TD width="40px"&gt;bind::esri:fieldType&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;text&lt;/TD&gt;&lt;TD width="123.675px"&gt;time_24h&lt;/TD&gt;&lt;TD width="95.85px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="183.975px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="127.117px"&gt;(int(substr(.,0,2))&amp;lt;24) and (int(substr(.,3,5))&amp;lt;60)&lt;/TD&gt;&lt;TD width="40px"&gt;null&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;date&lt;/TD&gt;&lt;TD width="123.675px"&gt;date_placehold&lt;/TD&gt;&lt;TD width="95.85px"&gt;12/31/1899&lt;/TD&gt;&lt;TD width="183.975px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="127.117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="40px"&gt;null&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD width="79.2917px"&gt;dateTime&lt;/TD&gt;&lt;TD width="123.675px"&gt;start_time&lt;/TD&gt;&lt;TD width="95.85px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="183.975px"&gt;if(${date_placehold} != '' and ${time_24h} != '', concat(format-date(${date_placehold}, '%Y-%m-%d'), 'T', format-date(${time_24h}, '%H:%M:%S')), '')&lt;/TD&gt;&lt;TD width="127.117px"&gt;&amp;nbsp;&lt;/TD&gt;&lt;TD width="40px"&gt;esriFieldTypeDate&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Essentially, the user will only see the &lt;STRONG&gt;${time_24h}&lt;/STRONG&gt; field. They will enter the time in 24-hour format, and this time will then be joined with a default date of &lt;EM&gt;12/31/1899&amp;nbsp;&lt;/EM&gt;to create the &lt;STRONG&gt;${start_time}&lt;/STRONG&gt; field. This is ultimately the value that gets stored when the user submits the survey. I have to use the &lt;EM&gt;esrifieldTypeDate&lt;/EM&gt;&amp;nbsp;because of the limitation when publishing a web layer with the "Time only" data type. It seems a bit convoluted, and I'm open to any better alternatives to achieve this outcome.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;So here's the issue between the web app/connect or field app:&lt;/P&gt;&lt;P&gt;In &lt;U&gt;connect&lt;/U&gt;, the user should be able to type 13:30 into ${time_24h} to trigger the calculate on ${start_time}. This results with "Saturday, December 31, 1899" "1:30PM". This functions exactly how I intend on connect/field app.&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, in the &lt;U&gt;web app&lt;/U&gt;, the user types 13:30 into&amp;nbsp;${time_24h} and no calculate is performed in&amp;nbsp;${start_time}.&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;I've read that dates are stored exclusively as decimal dates on the web app, so I think this is where my problem arises. Any input or suggestions to modify what I have would be appreciated.&amp;nbsp; &amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 20 Mar 2025 19:27:35 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-survey123-questions/recording-time-values-with-esrifieldtypedate/m-p/1597732#M61790</guid>
      <dc:creator>MIetronShahbodaghloo</dc:creator>
      <dc:date>2025-03-20T19:27:35Z</dc:date>
    </item>
  </channel>
</rss>

