Can you format the date to include day of week for a report?

Question

For a report, is there a way to output the day of the week? For instance, "Monday May 14, 2018" instead of "May 14, 2018"?

Based on the help it doesn't seem possible, but I figured it wouldn't hurt to ask.

Print survey results—Survey123 for ArcGIS | ArcGIS

ZhifangWang · Answer

Hi Rob,

In the report template, you can use the following syntax to get the day of the week, such as

* ${date1 | format: “dddd”} will return "Wednesday"

Additionally, you can try most of the formats listed in https://momentjs.com/docs/#/displaying/format/ which should also work. However, it's not officially supported yet and that's why we don't have them in the doc.

RobBlash · Answer

I wound up adding a hidden field with the following calc to get the short day ("Tue")

format-date(${WorkDate},'%a')

Then I went a step further using pulldata to get the long day (Tuesday)

pulldata('WeekdayLookup','DayLong','DayShort',format-date(${WorkDate},'%a'))