Format date time not working in Enketo

Support
, , , ,
1

Hello ODKers,

I am trying to convert a time question using format-date-time() . In enketo it is giving an output as "Invalid Date" where as in collect it is giving me the result what i need. Why is it not working in Enketo?

Thanks and Regards,
SGSC

Version 0.9: Enketo reports "invalid date" for a calculated date working in Collect
2

Hi @SGSC

Are you trying to convert time question only, or date time? The name even suggest is format-date-time.

If you use datetime it works in enketo, see the form format-date-time_test.xlsx (10.7 KB)

1 Like
3

Hi @dicksonsamwel,

I am converting time question only. But the conversion works fine in Collect but not in enketo. I am using this because to compare two time questions. Is there any other method to compare two time questions which works in both enketo and ODK Collect.

Thanks and Regards,
SGSC

4

Clarify more, how do you compare time??? If possible attach sample form

5

Please find the attachment .

TimeExample.xlsx (9.2 KB)

1 Like
6

See the attachment, that can be one way of doing that

TimeExample.xlsx (9.7 KB)

2 Likes
7

Thank you @dicksonsamwel.

2 Likes