Obtain day of the week

[PamelaLandy]

Hi, everybody In survey connect , Is it possible to obtain and save the name of the day that has been obtained from a date type  DateTime ? 

thanks in advanced

[Gerhard · Accepted solution]

Hi @PamelaLandy,

The way I'd tackle this is using the format-date-time function which allow you to convert date objects into strings. There's more info in the Dates and Time in Survey123 - Esri Community blog post, but I've taken the table below from that post and modified it to return just the three letter short text day (Sun, Mon, ...).

type	name	label	calculation
dateTime	wsdatetime	Sample Date/Time
calculate	wstime	Time	format-date(${wsdatetime},'%a')

[BrittanyBurson]

Perfect. Thank you!