I am trying to use "esriFieldTypeTimestampOffset" and "esriFieldTypeDateOnly" in the bind::esri::fieldType column to cut down on end user confusion about time zones; however, when exporting data from the Survey123 data website to an Excel document, the new field types have a leading backtick in the cells. The leading backtick is not present when exporting as a CSV, so I don't think it's in the data itself but is instead being added to the Excel cells in that column during the export process.
This happens whether I use dateTime or date in "Type" column and whether or not I also add dateTime and date to the bind::type column. It also happens whether or not I add "once" (e.g., "once(now())") to the calculation or leave it as "now()" or "today()".
Just FYI - it is NOT an apostrophe. It's actually what I assumed it was at first and tried to use the Text to Columns Excel feature to remove it. When that didn't work, I realized it was the backtick.
Anyone have any idea why it does this? Or, better yet, how to stop it? Attached is an admittedly messy copy of the exported results as I tried to play around with the fields.
Thanks!
