topic Dashboard data expression issue with Date fields in ArcGIS Dashboards Questions

topic Dashboard data expression issue with Date fields in ArcGIS Dashboards Questions https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-issue-with-date-fields/m-p/1599003#M10933 <P>Hello</P><P>I am creating a data expression in dashboard, trying to convert data fields (from Central Time to UTC). When I look at the individual features, it's working, everything looks like I want it. However, when I push to the featureset to be used in a table , ALL the date fields have the same values... </P><P>What am I doing wrong?</P><P>Thanks!</P><LI-CODE lang="javascript">var portal = Portal('https://www.arcgis.com'); var fs = FeatureSetByPortalItem( portal, '1b32fd673de04b16b15bf5a923b7d1fb', 0, [ 'dr_DateTime', 'dr_DateText' ], false ); // return fs var features = []; var feat; // Populate feature array for (var f in fs) { feat = { 'attributes': { 'dr_DateTimeMd': ChangeTimeZone(f['dr_DateTime'],"+06:00"), 'dr_DateTimeF': f['dr_DateTime'], 'dr_DateTimeUTCF': ToUTC(f['dr_DateTime']), 'dr_DateTextF': f['dr_DateText'] }} Push(features, feat); }; // return features var dowDict = { 'fields': [ {'name': 'dr_DateTimeMd', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTimeF', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTimeUTCF', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTextF', 'type': 'esriFieldTypeString'} ], 'geometryType': '', 'features': features }; // Convert dictionary to feature set. var fs_dict = FeatureSet(dowDict); return fs_dict</LI-CODE><P> </P><P>raw featureset</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_0-1742914523140.png" style="width: 342px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128623i97C5AC3EED077A36/image-dimensions/342x222?v=v2" width="342" height="222" role="button" title="DominicRobergeIADOT_0-1742914523140.png" alt="DominicRobergeIADOT_0-1742914523140.png" /></span></P><P> </P><P>Each individual features:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_1-1742914564322.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128624i97C0D45890B40BE6/image-size/medium?v=v2&px=400" role="button" title="DominicRobergeIADOT_1-1742914564322.png" alt="DominicRobergeIADOT_1-1742914564322.png" /></span></P><P> </P><P>Final featureset</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_2-1742914589773.png" style="width: 641px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128625i2A5F27A833D87E7C/image-dimensions/641x202?v=v2" width="641" height="202" role="button" title="DominicRobergeIADOT_2-1742914589773.png" alt="DominicRobergeIADOT_2-1742914589773.png" /></span></P><P> </P><P> </P> Tue, 25 Mar 2025 14:58:03 GMT DominicRobergeIADOT 2025-03-25T14:58:03Z Dashboard data expression issue with Date fields https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-issue-with-date-fields/m-p/1599003#M10933 <P>Hello</P><P>I am creating a data expression in dashboard, trying to convert data fields (from Central Time to UTC). When I look at the individual features, it's working, everything looks like I want it. However, when I push to the featureset to be used in a table , ALL the date fields have the same values... </P><P>What am I doing wrong?</P><P>Thanks!</P><LI-CODE lang="javascript">var portal = Portal('https://www.arcgis.com'); var fs = FeatureSetByPortalItem( portal, '1b32fd673de04b16b15bf5a923b7d1fb', 0, [ 'dr_DateTime', 'dr_DateText' ], false ); // return fs var features = []; var feat; // Populate feature array for (var f in fs) { feat = { 'attributes': { 'dr_DateTimeMd': ChangeTimeZone(f['dr_DateTime'],"+06:00"), 'dr_DateTimeF': f['dr_DateTime'], 'dr_DateTimeUTCF': ToUTC(f['dr_DateTime']), 'dr_DateTextF': f['dr_DateText'] }} Push(features, feat); }; // return features var dowDict = { 'fields': [ {'name': 'dr_DateTimeMd', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTimeF', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTimeUTCF', 'type': 'esriFieldTypeDate'}, {'name': 'dr_DateTextF', 'type': 'esriFieldTypeString'} ], 'geometryType': '', 'features': features }; // Convert dictionary to feature set. var fs_dict = FeatureSet(dowDict); return fs_dict</LI-CODE><P> </P><P>raw featureset</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_0-1742914523140.png" style="width: 342px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128623i97C5AC3EED077A36/image-dimensions/342x222?v=v2" width="342" height="222" role="button" title="DominicRobergeIADOT_0-1742914523140.png" alt="DominicRobergeIADOT_0-1742914523140.png" /></span></P><P> </P><P>Each individual features:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_1-1742914564322.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128624i97C0D45890B40BE6/image-size/medium?v=v2&px=400" role="button" title="DominicRobergeIADOT_1-1742914564322.png" alt="DominicRobergeIADOT_1-1742914564322.png" /></span></P><P> </P><P>Final featureset</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DominicRobergeIADOT_2-1742914589773.png" style="width: 641px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/128625i2A5F27A833D87E7C/image-dimensions/641x202?v=v2" width="641" height="202" role="button" title="DominicRobergeIADOT_2-1742914589773.png" alt="DominicRobergeIADOT_2-1742914589773.png" /></span></P><P> </P><P> </P> Tue, 25 Mar 2025 14:58:03 GMT https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-data-expression-issue-with-date-fields/m-p/1599003#M10933 DominicRobergeIADOT 2025-03-25T14:58:03Z