Doing a Calculation on DATE data from pulldata function

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

In the survey tab of your XLSForm:

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:

Reference XLSForm:

Pull Data for Dates.xls (34.5 KB)

Reference CSV file:

Codes.csv (239 Bytes)

1 Like