Dear all,Please I am a novice to ODK. Currently I'm working on a
questionnaire and I have reached a place where I suppose to add two weeks
to the current date.How Could I do it?
with the newest ODK Collect 1.4, you can do
calculate="date-time(decimal-date-time(${dateField})+14)"
Note that there are several issues with preserving the time portion of a
date during calculations like this, so you may or may not be able to
preserve the time-of-day.
Mitch
···
On Tue, Oct 1, 2013 at 10:46 PM, Justine Govella wrote:Dear all,Please I am a novice to ODK. Currently I'm working on a
questionnaire and I have reached a place where I suppose to add two weeks
to the current date.How Could I do it?--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
In the above, I mean put the
date-time(decimal-date-time(${dateField})+14)
in the 'calculation' column of the XLSForm.
I was mixing the constructions in the XML and XLS
···
On Wed, Oct 2, 2013 at 9:39 AM, Mitch Sundt wrote:with the newest ODK Collect 1.4, you can do
calculate="date-time(decimal-date-time(${dateField})+14)"
Note that there are several issues with preserving the time portion of a
date during calculations like this, so you may or may not be able to
preserve the time-of-day.Mitch
On Tue, Oct 1, 2013 at 10:46 PM, Justine Govella jgovella@ihi.or.tzwrote:
Dear all,Please I am a novice to ODK. Currently I'm working on a
questionnaire and I have reached a place where I suppose to add two weeks
to the current date.How Could I do it?--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Dear esteemed
I am working on an ODK XLS form and I wish to calculate the difference between two datefields and then divide by 7.
I would love the answer to be rounded up
In excel it would look like this (x1-x2)/7.
The idea is to get the number of weeks.
Kindly help.thanks
Date arithmetic in ODK Collect has several bugs that can lead to off-by-one
errors (particularly when working in different time zones or transitioning
between daylight savings time and standard time); time arithmetic is even
less certain.
Be sure to test your form to make sure it works as you expect.
That said, there are a number of functions for date arithmetic. See:
in particular, "date, dateTime, time as number"
···
On Fri, Apr 3, 2015 at 2:03 AM, wrote:Dear esteemed
I am working on an ODK XLS form and I wish to calculate the difference
between two datefields and then divide by 7.
I would love the answer to be rounded upIn excel it would look like this (x1-x2)/7.
The idea is to get the number of weeks.
Kindly help.thanks--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en
You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com
Dear all,
I want to define between 2010-01-01 and current date . How can design in odk excel. Pleases! help
Do you want to restrict to put dates between the dates you mentioned? If so you can check the discussion Constraint on date - #3 by Fula