Pull data date value

User Support Form Building
, ,
1

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.

2

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:

Image 1
Image 1989×239 8.4 KB

csv file:
Image 2

Data entry screen as seen in Enketo:

Image 3
Image 3575×775 18.9 KB

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

Reference csv file:
Codes.csv (227 Bytes)

Have a great day!

3 Likes
3

Thank you very much!

2 Likes