Dates not formatting in Survey123 Template Reports

Question

Hi, When I print out a report with a template in MySurveys and have the report labeled with ${FAC_NAME} and ${INSP_DATE}, the facility name works, but the inspection date gives numbers like 1587668400000. Is there somewhere I am supposed to be formatting the date in the Excel to fix this? I have it as type=date, name=INSP_DATE, default=now()

Thanks, Debby

DominickBernstein2 · Answer

Hello James,

I created a report template for a project and every expression works with my survey except the field that records the date of the survey. In the survey the field is called date_of_flow_test. In the report template I have it as ${date_of_flow_test}. When I generate a report that expression does not yield a result. Do you know what may be causing this?

JamesTedrick · Answer

Hi Debra,

Apologies for the delay in response. Can you try to applying a date formatting Feature report templates—Survey123 for ArcGIS | Documentation , as it looks like you are seeing the timestamp value of the date?