Unix time calculation not populating correct date in survey

[dwold]

I am trying to convert Unix time to mm/dd/yyyy in a survey. I am pulling data from a feature layer into this survey using the pulldata("@layer"). I tried following this document but for some reason, my calculations are not population the correct date.

Feature Layer Dates I am pulling from:

Survey:

Web format:

@IsmaelChivite anything you see in the table that isn't allowing the conversion to be made?

[DougBrowning]

On those 2 note fields that get the times try setting the bind:type column to int.  It will treat those note fields as string in the web app by default.  This usually leads to a cocat vs a +,  Never seen it on divide but worth a shot.

Hopefully that does it.

[dwold]

thanks @DougBrowning for the suggestion. I appreciate it! Unfortunately, that didn't do the trick. It's very puzzling why it won't convert.

[DougBrowning]

Did you set the bind on the hidden fields line 12 and 13 also?

[dwold]

@DougBrowning still getting some funky output after changing the blind type to int. Very puzzling why it won't convert.

[DougBrowning]

I think you use unix time for calcs but for display you need to format it I think?

format-date()

Fits an existing date or time value to a defined format.

format-date(${previous_time}, '%H:%M')

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION2_AF58C02...