Derived day for the date (ex: 24/07/2023 —> Monday)

Can anyone tell me how to derive the day from the date in Kobo date type question?
(ex: 24/07/2023 —> Monday)

See %a option in format-date function: ODK XForms Specification .

Hint: The day value given depends on the recent form language. So, if you use it for expressions (e.g. in an if clause) in a multiple language form, you need to use a … = format-date( aWeekDayDate, a% ) comparison.

1 Like

@dimesh, as advised by @wroos, you should be able to do it as oulitned in the image shared below:

In the survey tab of your XLSForm:

Data entry screen as seen in Enketo:

Reference XLSForm:

Date.xlsx (16.5 KB)

1 Like

@Kal_Lam thank you so much. it works

1 Like