Doing a Calculation on DATE data from pulldata function

User Support Form Building
, , , ,
6

@Tumaini, @cjneisa, you could do it as outlined below:

In the survey tab of your XLSForm:

Image 1
Image 11137×409 29.2 KB

In the choices tab of your XLSForm:

Image 2

Note: You will need to convert your date (i,e, E2 to E3) to Epoch date manually through this site here. At the moment, the system will only allow you to do the calculation for a pulled date (from CSV file) by converting the time stamp to Epoch.

Data entry screen as seen in Enketo:

Image 3
Image 3614×953 25 KB

Reference XLSForm:

Pull Data for Dates.xls (34.5 KB)

Reference CSV file:

Codes.csv (239 Bytes)

1 Like