I am entering a survey in to Excel and have run in to a problem. I would
like the person being interviewed to say the "birthdate" of her child.
Then I want to calculate the child's age in months (using the date of
interview) from that birthdate. Previously on this community board,
someone suggested using Excel functions to do so, but I can't seem to get
that to work since it would be referring to cells that are "names" rather
than numbers at this point.

I have attached the file, please refer to lines 16-19.

Any suggestions? I would like the child's age to be in months (rounded to
the nearest hundredth).

No need for an Excel function. Internal javarosa functions can be used. Use
a calculate field type then

for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)

With the assumption that system date is correct.

···
On Thursday, September 27, 2012, Lisa Zook wrote:

Hi,

I am entering a survey in to Excel and have run in to a problem. I would
like the person being interviewed to say the "birthdate" of her child.
Then I want to calculate the child's age in months (using the date of
interview) from that birthdate. Previously on this community board,
someone suggested using Excel functions to do so, but I can't seem to get
that to work since it would be referring to cells that are "names" rather
than numbers at this point.

I have attached the file, please refer to lines 16-19.

Any suggestions? I would like the child's age to be in months (rounded to
the nearest hundredth).

···
On Thursday, September 27, 2012 1:35:55 AM UTC-7, ニコノコ wrote:

No need for an Excel function. Internal javarosa functions can be used.
Use a calculate field type then

for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)

With the assumption that system date is correct.

On Thursday, September 27, 2012, Lisa Zook wrote:

Hi,

I am entering a survey in to Excel and have run in to a problem. I would
like the person being interviewed to say the "birthdate" of her child.
Then I want to calculate the child's age in months (using the date of
interview) from that birthdate. Previously on this community board,
someone suggested using Excel functions to do so, but I can't seem to get
that to work since it would be referring to cells that are "names" rather
than numbers at this point.

I have attached the file, please refer to lines 16-19.

Any suggestions? I would like the child's age to be in months (rounded
to the nearest hundredth).

you should use "div" and not "/" for division operations. See my example.

···
On Friday, September 28, 2012, Lisa Zook wrote:

Hi there,

Thank you for your response. When I do this, I am not getting anything to
calculate.

Please see line 16 (the calculate line) and then line 17, where i ask for
it to display that calculation. Currently, nothing displays.

Any suggestions?

On Thursday, September 27, 2012 1:35:55 AM UTC-7, ニコノコ wrote:

No need for an Excel function. Internal javarosa functions can be used.
Use a calculate field type then

for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)

With the assumption that system date is correct.

On Thursday, September 27, 2012, Lisa Zook wrote:

Hi,

I am entering a survey in to Excel and have run in to a problem. I
would like the person being interviewed to say the "birthdate" of her
child. Then I want to calculate the child's age in months (using the date
of interview) from that birthdate. Previously on this community board,
someone suggested using Excel functions to do so, but I can't seem to get
that to work since it would be referring to cells that are "names" rather
than numbers at this point.

I have attached the file, please refer to lines 16-19.

Any suggestions? I would like the child's age to be in months (rounded
to the nearest hundredth).

···
On Thursday, September 27, 2012 2:05:55 PM UTC+5:30, ニコノコ wrote:
> No need for an Excel function. Internal javarosa functions can be used. Use a calculate field type then
> for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
>
> for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)
>
> With the assumption that system date is correct.
>
>
>
> On Thursday, September 27, 2012, Lisa Zook wrote:
>
> Hi,
>
>
>
> I am entering a survey in to Excel and have run in to a problem. I would like the person being interviewed to say the "birthdate" of her child. Then I want to calculate the child's age in months (using the date of interview) from that birthdate. Previously on this community board, someone suggested using Excel functions to do so, but I can't seem to get that to work since it would be referring to cells that are "names" rather than numbers at this point.
>
>
>
>
> I have attached the file, please refer to lines 16-19.
>
>
>
> Any suggestions? I would like the child's age to be in months (rounded to the nearest hundredth).
>
>
>
> Thanks so much!
>
>
>
> Lisa
>
>
>
>
>
>
>
>
> --
>
> Post: opendatakit@googlegroups.com
>
> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
>
> Options: http://groups.google.com/group/opendatakit?hl=en

I was not aware int() was a supported function in javarosa. Was support
added by ODK or is it accidentally working (because it works natively in
java or something)?

···
On Thursday, September 27, 2012 6:50:20 PM UTC-6, ニコノコ wrote:
>
> you should use "div" and not "/" for division operations. See my example.
>
> On Friday, September 28, 2012, Lisa Zook wrote:
>
>> Hi there,
>>
>> Thank you for your response. When I do this, I am not getting anything
>> to calculate.
>>
>> Please see line 16 (the calculate line) and then line 17, where i ask for
>> it to display that calculation. Currently, nothing displays.
>>
>> Any suggestions?
>>
>>
>> On Thursday, September 27, 2012 1:35:55 AM UTC-7, ニコノコ wrote:
>>
>>> No need for an Excel function. Internal javarosa functions can be used.
>>> Use a calculate field type then
>>>
>>> for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
>>> for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)
>>>
>>> With the assumption that system date is correct.
>>>
>>> On Thursday, September 27, 2012, Lisa Zook wrote:
>>>
>>>> Hi,
>>>>
>>>> I am entering a survey in to Excel and have run in to a problem. I
>>>> would like the person being interviewed to say the "birthdate" of her
>>>> child. Then I want to calculate the child's age in months (using the date
>>>> of interview) from that birthdate. Previously on this community board,
>>>> someone suggested using Excel functions to do so, but I can't seem to get
>>>> that to work since it would be referring to cells that are "names" rather
>>>> than numbers at this point.
>>>>
>>>> I have attached the file, please refer to lines 16-19.
>>>>
>>>> Any suggestions? I would like the child's age to be in months (rounded
>>>> to the nearest hundredth).
>>>>
>>>> Thanks so much!
>>>>
>>>> Lisa
>>>>
>>>>
>>>>
>>>> --
>>>> Post: opendatakit@googlegroups.com
>>>> Unsubscribe: opendatakit+unsubscribe@**googlegroups.com
>>>> Options: http://groups.google.com/**group/opendatakit?hl=en
>>>>
>>> --
>> Post: opendatakit@googlegroups.com
>> Unsubscribe: opendatakit+unsubscribe@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>

Note that the source code, linked off that page, is the best resource for
determining exactly what functions are or are not available.

···
On Tue, Oct 2, 2012 at 9:28 AM, Martijn van de Rijdt wrote:

I was not aware int() was a supported function in javarosa. Was support
added by ODK or is it accidentally working (because it works natively in
java or something)?

On Thursday, September 27, 2012 6:50:20 PM UTC-6, ニコノコ wrote:

you should use "div" and not "/" for division operations. See my example.

On Friday, September 28, 2012, Lisa Zook wrote:

Hi there,

Thank you for your response. When I do this, I am not getting anything
to calculate.

Please see line 16 (the calculate line) and then line 17, where i ask
for it to display that calculation. Currently, nothing displays.

Any suggestions?

On Thursday, September 27, 2012 1:35:55 AM UTC-7, ニコノコ wrote:

No need for an Excel function. Internal javarosa functions can be used.
Use a calculate field type then

for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)

With the assumption that system date is correct.

On Thursday, September 27, 2012, Lisa Zook wrote:

Hi,

I am entering a survey in to Excel and have run in to a problem. I
would like the person being interviewed to say the "birthdate" of her
child. Then I want to calculate the child's age in months (using the date
of interview) from that birthdate. Previously on this community board,
someone suggested using Excel functions to do so, but I can't seem to get
that to work since it would be referring to cells that are "names" rather
than numbers at this point.

I have attached the file, please refer to lines 16-19.

Any suggestions? I would like the child's age to be in months
(rounded to the nearest hundredth).

···
On Thursday, October 4, 2012 2:33:34 PM UTC-6, Mitch wrote:
>
> I've updated the documentation at
> http://opendatakit.org/help/form-design/binding/
>
> Note that the source code, linked off that page, is the best resource for
> determining exactly what functions are or are not available.
>
> On Tue, Oct 2, 2012 at 9:28 AM, Martijn van de Rijdt <mri...@gmail.com wrote:
>
>> I was not aware int() was a supported function in javarosa. Was support
>> added by ODK or is it accidentally working (because it works natively in
>> java or something)?
>>
>>
>> On Thursday, September 27, 2012 6:50:20 PM UTC-6, ニコノコ wrote:
>>>
>>> you should use "div" and not "/" for division operations. See my example.
>>>
>>> On Friday, September 28, 2012, Lisa Zook wrote:
>>>
>>>> Hi there,
>>>>
>>>> Thank you for your response. When I do this, I am not getting anything
>>>> to calculate.
>>>>
>>>> Please see line 16 (the calculate line) and then line 17, where i ask
>>>> for it to display that calculation. Currently, nothing displays.
>>>>
>>>> Any suggestions?
>>>>
>>>>
>>>> On Thursday, September 27, 2012 1:35:55 AM UTC-7, ニコノコ wrote:
>>>>
>>>>> No need for an Excel function. Internal javarosa functions can be
>>>>> used. Use a calculate field type then
>>>>>
>>>>> for age in years, use: int((today() - ${BIRTH_DATE}) div 365.24)
>>>>> for age in months, use: int((today() - ${BIRTH_DATE}) div 30.44)
>>>>>
>>>>> With the assumption that system date is correct.
>>>>>
>>>>> On Thursday, September 27, 2012, Lisa Zook wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I am entering a survey in to Excel and have run in to a problem. I
>>>>>> would like the person being interviewed to say the "birthdate" of her
>>>>>> child. Then I want to calculate the child's age in months (using the date
>>>>>> of interview) from that birthdate. Previously on this community board,
>>>>>> someone suggested using Excel functions to do so, but I can't seem to get
>>>>>> that to work since it would be referring to cells that are "names" rather
>>>>>> than numbers at this point.
>>>>>>
>>>>>> I have attached the file, please refer to lines 16-19.
>>>>>>
>>>>>> Any suggestions? I would like the child's age to be in months
>>>>>> (rounded to the nearest hundredth).
>>>>>>
>>>>>> Thanks so much!
>>>>>>
>>>>>> Lisa
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Post: opendatakit@googlegroups.com
>>>>>> Unsubscribe: opendatakit+unsubscribe@**google**groups.com
>>>>>> Options: http://groups.google.com/**group**/opendatakit?hl=en
>>>>>>
>>>>> --
>>>> Post: opendatakit@googlegroups.com
>>>> Unsubscribe: opendatakit+unsubscribe@**googlegroups.com
>>>> Options: http://groups.google.com/**group/opendatakit?hl=en
>>>>
>>> --
>> Post: opend...@googlegroups.com
>> Unsubscribe: opendatakit...@googlegroups.com
>> Options: http://groups.google.com/group/opendatakit?hl=en
>>
>
>
>
> --
> Mitch Sundt
> Software Engineer
> University of Washington
> mitche...@gmail.com
>