Pull data date value

Hi, I have a question about how to pull data function to show dates in a form.

I am using this function: pulldata(‘csv_file’,‘date’,‘value’,${id)

But when I convert the file in a csv file, the date (YYYY,mm,dd) change to an integer and I could’nt convert the value (12345) to a date value.

Thank you.

Hi @segadu78,

Welcome to the community! The date format should work with pull data. As a reference kindly please have a look at the images shared below:

In the survey tab of your xlsform:

csv file:
Image 2

Data entry screen as seen in Enketo:

Reference xlsform:
Pull Data for Dates.xls (33.5 KB)

Reference csv file:
Codes.csv (227 Bytes)

Have a great day!


Thank you very much!