Is it possible to use Left function in kobocollect

I want to keep the year from date of birth. for example 2019-03-28 I want to keep only 2019.
Is this possible in kobocollect.

Thank you!

Hi @DJAA,

I think you can achieve that by using format-date function.

Best,

2 Likes

@DJAA, or maybe you could also simply use the appearance to extract the date as shown in the image below:

In the survey tab of your XLSForm:

Image 1

Data entry screen as seen in Enketo:

Image 2

Reference XLSForm:

Date.xlsx (16.5 KB)

1 Like